Pop up alerts based on date+time values

[excelakos]

Hi there,
I have a column (pivot table) that has cells in date+time format, the size of the column will not be standard
I need to get pop alerts 8 minutes (or what ever i will decide) before each cell's value.
I need the pop up to show above any other application at the time. It means i may have my excel book minimized and working in something else but when criteria is met i need it to pop up in my screen
Is there any code to do this?
I need a pop up alert when 17/3/2017 21:38 for the fisrt value in example.

Excel 2010 64 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH][/TH]
[TH]

M​

[/TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

2​

[/TD]
[TD="bgcolor: #DDEBF7"]ÅôéêÝôåò ãñáììÞò[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

3​

[/TD]
[TD]17/3/2017 21:45[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

4​

[/TD]
[TD]18/3/2017 14:00[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

5​

[/TD]
[TD]18/3/2017 14:30[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

6​

[/TD]
[TD]18/3/2017 17:00[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

7​

[/TD]
[TD]18/3/2017 17:15[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

8​

[/TD]
[TD]18/3/2017 19:00[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

9​

[/TD]
[TD]18/3/2017 19:30[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

10​

[/TD]
[TD]18/3/2017 21:45[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

11​

[/TD]
[TD]19/3/2017 13:00[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

12​

[/TD]
[TD]19/3/2017 13:30[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

13​

[/TD]
[TD]19/3/2017 14:00[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

14​

[/TD]
[TD]19/3/2017 16:00[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

15​

[/TD]
[TD]19/3/2017 16:15[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

16​

[/TD]
[TD]19/3/2017 17:15[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

17​

[/TD]
[TD]19/3/2017 18:30[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

18​

[/TD]
[TD]19/3/2017 19:00[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

19​

[/TD]
[TD]19/3/2017 19:30[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

20​

[/TD]
[TD]19/3/2017 21:45[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

21​

[/TD]
[TD="bgcolor: #DDEBF7"]Ãåíéêü ¢èñïéóìá[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Picks[/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

It should be possible using OnTime code, and reading down the list to set the next time minus 8 minutes to throw a message box (off the top of my head, but I have no idea where to start building that into a working code for you)

 

[excelakos]

Hi mole999. Well there will be a cell (lets say A1) with =Now() function. So there could be a vba which look each of the column's cell and "test if" . I have seen others doing it with just date but i need time too.