How to generate the pop-up in Excel before 5 minutes of actual time

Hi All,

Could you please help me on the below scenario,

i need to generate the pop-up in the excel VBA using Macros.
The scenario is the Excel Sheet has some user mentioned time in the Column B as,
13:00:00
13:05:00
14:00:00
14:05:00

for the above mentioned time i need to get the pop-up window before 5 minutes saying "The time is due in the five minutes".

Below is the code which i scripted but still unable to get the pop-up before the five minutes, Also i need this macro to be run for every 30 seconds when sheet is opened.

Please Login or Register  to view this content.

could any one please help me on this

Thanks in advance