What do I need to do if I want to run a macro 10 seconds after I open a form. I tried the Timer Interval but it keeps running the macro every 10 seconds.
One way is to run a line of code after your macro has run the first time, along the lines of Me.TimerInterval = 0.
you will need to add a similar line to the forms OnOpen event to reset the timer to 10secs (remember that the timer interval is shown in milliseconds...)
HTH
Nigel Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.