View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
 
Posts: 173
Default Run Time macro based on the value in cell

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