Run message box when cell value time is exceed system time

[tohobaby]

Hi,

I have a excel file.

I wish to write a vba script to compare the system time and the cell value time.

If system time is exceed the cell value time, it will show a pop out message to inform user that, the time is exceed.

My file will look like this:

Untitled.png

I have been research a while but seem like only vba code will able to complete this requirement.

[Kaper]

If msgbox shall pop up when somebody enters value which is before system time - you shall write code for Worksheet Change event
If the checking time shall occur in bacground I'd recommend programming OnTime and repeatedly (if it's not fraction of second critical), say every 10 seconds check last cell in column N if it is not earlier than system time.

Which is your case? And ... having above tip (so knowing what to search) can you write it yourself?