Thread: [Solved] Run a macro each minute?
View Single Post
 
Old 05-31-2012, 01:01 AM
yabbah yabbah is offline Windows XP Office 2007
Novice
  
Join Date: Mar 2012
Posts: 8
yabbah is on a distinguished road
Default
I solved it using this line in the vba,
Application.OnTime Now + TimeValue("00:00:10"), "nameOfMyMacro"

Thanks all for your help.
Reply With Quote