how to make reminder in excel .

[deaa_6]

I have excel file Use it as a reminder of the daily work ...

What a way to make a timer in Excel
If time is in the computer match with the time in the cell change color.

Example:

Computer time 5:15
I have work at 06:00 and I've written this time in a cell, Excel
If computer clock match with working time Automatically change the color of the cell

 

[pedie]

try link

 

[deaa_6]

try link

Thank you dear,
But the idea of the project, said alert is triggered automatically between these times

 

[Deepak9930]

roughly and quick way...

running time. Enter both the code in standard module and run timer..
Dim NextTick As Date
Sub timer()
Range("A1").Value = CDbl(Time)
NextTick = Now + TimeValue("00:00:01")
Application.OnTime NextTick, "timer"
alertme
End Sub

then for example you can enter time in range "b2" when you want the pop up...

another try..
sub alertme
if range("B1").value < range("A1").value then
msgbox "Alert...times up"
On Error Resume Next
Application.OnTime NextTick, "timer", , False
end if
end sub

How I can use it ... can you help me with example sheet