Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear Expert,
Currently, I am running a time macro ... I have to change the time in VB script. Is it pssible for me to set the time in cell E2 and then run the time maco based on the value in cell E2 ? Thanks Sub StartTimer() CreateObject("WScript.Shell").Popup "Macro is going to run on scheduled time.", 2, "Thank you very much for your cooperation" RunWhen = TimeSerial(3, 30, 0) Application.OnTime EarliestTime:=RunWhen, Procedu=cRunWhat, _ Schedule:=True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Running a macro based on the time | Excel Discussion (Misc queries) | |||
Run Macro Based On Time | Excel Worksheet Functions | |||
Run macro based on time | Excel Worksheet Functions | |||
Time based macro | Excel Programming | |||
Time based macro | Excel Programming |