Checking of date and every 5 minute-time

[RiaMelissaJaravata]

Hello All,

I am very new to VBA programming. Can someone please give me a short code for determining if the details of one column has the date today plus the every 5-minute interval (0h00, 00h05...). And if it has missing data or incorrect date, it will display "Missing data, bla bla" and exits the file. Or much better if the incorrect data is highlighted, but not really that necessary.
Example is the one below:


Edited... With Attachment...

 

[vletm]

something like this ..
press the button

 

[NARAYANK991]

Hi ,

This can be done without using VBA too ; all that is required is a helper column , which has all the times from 00:00 till 23:55 , in steps of 5 minutes.

Now you can compare the existing data with the data in this helper column. Differences , if any , can be highlighted using Conditional Formatting.

As it stands , your data is all correct.

See the attached file.

Narayan