Run message box when cell value time is exceed system time

[kimberly090]

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:

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

 

[mick0005]

Use data validation.

Select the Allow drop down as Time for Data choose greater than and for Start Time type =NOW()

In the error alert tab you can type whatever message you want if someone types the a time in that is earlier than now.