Run a macro each minute?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Run a macro each minute?

FAQ

Thread Tools

Display Modes

05-29-2012, 12:29 AM

krishnaoptif krishnaoptif is offline

Windows XP Run a macro each minute?

Office 2007

Novice

Join Date: May 2012

Posts: 23

Hi,
Please use below code and call your macro in this...

Quote:

Option Explicit
Sub AutoRunAfter1Minute()

Dim i As Long
'i is minute...

For i = 1 To 5000

'Call your Macro or Your Code
MsgBox "Your Macro"

Application.Wait (Now + TimeValue("0:01:00"))

Next i

End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to write the degree, minute second format in excel	Jamal NUMAN	Excel	12	07-09-2018 11:44 PM
How do I assign a macro to a button when the macro is in my personal workbook?	foolios	Excel Programming	2	07-27-2011 02:41 PM
Upgraded from Outlook 2003 to 2010, after a minute, Outlook closes on its own	Ckingfly	Outlook	3	06-12-2011 07:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:04 AM.