Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Recurring Excel macro call (Read 3259 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Recurring Excel macro call
29.07.11 at 11:50:11
 
Recurring Excel macro call
 
Sometimes it is handy to schedule a macro in Excel. In the example below the hi macro is scheduled to run after 5 seconds. Note that in the subroutine below a call is made schedule itself.  
 
Sub Hi()
  MsgBox "Hi"
  Application.OnTime Now() + TimeValue("00:00:05"), "hi"
End Sub
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1