Hi,
thanks again for your help. I have another question.
Right now my macro change every second in this way...
the value in B2 is in this format
thanks again for your help. I have another question.
Right now my macro change every second in this way...
Is it possible to run myMacro everytime the value in B2 of sheet1 changes?Sub Autpen()
Application.OnTime Now, "myMacro"
End Sub
Sub BAuto_Close()
Application.OnTime mdNextTime1, "myMacro", , False
End Sub
Sub usaShares()
......
......
mdNextTime1 = Now + TimeValue("00:00:01")
Application.OnTime mdNextTime1, "myMacro"
Application.ScreenUpdating = True
End Sub
the value in B2 is in this format
Thanks in advance...16:49:59