use application ontime method for this.
This is a discussion on how to make reminder in excel . within the Excel Questions forums, part of the Question Forums category; I have excel file Use it as a reminder of the daily work ... What a way to make a ...
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
use application ontime method for this.
Regards,
Pedie
MS OFFICE 2013/EXCEL 2007: Window7: 64BIT
You can do this with conditional formatting on the cell containing the time.
Such that if K5 is the cell with the time, a conditional format formula would look like:This would reset every day however.Code:=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))>=K5
You would need to utilize a full date/time to make it persistent, which goes to a different formula.
Win7::MSO2007
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I have no special talent.
I am only passionately curious. - Albert Einstein
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Simple" and "Easy" are a matter of perspective
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Solutions here may be 'representative' and you may
need to actually put some thought to your own needs.
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
Last edited by pedie; Jan 21st, 2011 at 10:55 PM.
Regards,
Pedie
MS OFFICE 2013/EXCEL 2007: Window7: 64BIT
http://www.herosh.com/download/72373...t._2_.xls.html
can you do it in this file
sure lemmi check
Regards,
Pedie
MS OFFICE 2013/EXCEL 2007: Window7: 64BIT
As i check your sheet it does not give much explaination...
Not sure what to do..
Regards,
Pedie
MS OFFICE 2013/EXCEL 2007: Window7: 64BIT
Like this thread? Share it with others