Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Execute a macro after X time

Status
Not open for further replies.

OomJan

Technical User
Feb 16, 2005
4
NL
I want to know how I can execute a macro after a certain time.

Something like

Privatesub program(after5 minutes)
program
endsub


I have a macro that displayes some values. I need to refresh them from time to time.
How is this achieved?

Thankx

Oom Jan
 
Hi Oom Jan,

Tak a look at the Application.OnTime method.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top