Check Date and Time in range and show Msgbox

hi.
Hi, how check date in column A and time in column B compare with system date and show msgbox?
Date Time
20/07/2016 09:00
21/07/2016 09:00
22/07/2016 09:37
23/07/2016 09:38
24/07/2016 09:00
25/07/2016 09:00
26/07/2016 09:46
27/07/2016 09:00
28/07/2016 09:55
29/07/2016 09:00
30/07/2016 09:00
31/07/2016 09:00

Please Login or Register  to view this content.

Cross-Post
http://www.mrexcel.com/forum/excel-q...ow-msgbox.html

Thanks

In words, you say you are looking for the date (which will find a match) but in code you are looking for a time (which probably won't match). To display the time for today's date from your table, just use

Please Login or Register  to view this content.

After run your code, if i have same time and diferents day code not show nothing
Data Tempo
20/07/2016 09:00:00
21/07/2016 09:00:00
22/07/2016 09:37:00
02/08/2016 17:45:00
03/08/2016 17:45:00
25/07/2016 09:00:00
26/07/2016 09:46:00
27/07/2016 09:00:00
28/07/2016 09:55:00
29/07/2016 09:00:00
30/07/2016 09:00:00
31/07/2016 09:00:00
Why happening it?

Try my file, attached - this picture is what I get when I run my amended macro:

Capture.JPG

But if not find date and not find time equal system date/time, not show nothing.
do your teste.
dd/MM/yyyy
04/08/2016 and time 08:19, but in column B time is 08:10, show 04/08/2016 - 08:10, correct show exact time system

I just don't understand what the values in column B are there for then....

Please Login or Register  to view this content.