jazznaura
12-17-2008, 06:33 AM
Hi all,
I?m trying to get XLD's macro to work from http://vbaexpress.com/forum/showthread.php?t=13017&highlight=TIMER (http://vbaexpress.com/forum/showthread.php?t=13017&highlight=TIMER) but have failed. It keeps coming up with an error with the below:
Application.OnTime Now + nElapsed, "Closedown", , False
also tried, with no luck:
Application.OnTime Now + nElapsed, "Closedown", schedule:=False
I come across this before and can?t figure out what I did to correct this and turn the timer off. Using Excel 2002
Could anyone please help !!
Thanks,
I?m trying to get XLD's macro to work from http://vbaexpress.com/forum/showthread.php?t=13017&highlight=TIMER (http://vbaexpress.com/forum/showthread.php?t=13017&highlight=TIMER) but have failed. It keeps coming up with an error with the below:
Application.OnTime Now + nElapsed, "Closedown", , False
also tried, with no luck:
Application.OnTime Now + nElapsed, "Closedown", schedule:=False
I come across this before and can?t figure out what I did to correct this and turn the timer off. Using Excel 2002
Could anyone please help !!
Thanks,