Macro runs every X minutes

[mroseto]

Hello all,

I know this is posted here, but I cant seem to get it to work. I have a macro that I want to run every 30 minutes or so. I may make it every hour, I haven't decided. After looking through all the posts on here I can't get it to work.

I know I have to use onTime but I have no idea how to make it work. Any help would be much appreciated.

Thanks

Mike

 

[SteveO59L]

From Excel help

Example
This example runs my_Procedure 15 seconds from now.

Application.OnTime Now + TimeValue("00:00:15"), "my_Procedure"

This example runs my_Procedure at 5 P.M.

Application.OnTime TimeValue("17:00:00"), "my_Procedure"

This example cancels the OnTime setting from the previous example.

Application.OnTime EarliestTime:=TimeValue("17:00:00"), _
Procedure:="my_Procedure", Schedule:=False

 

[mroseto]

I can get that, but how do I reset it so it runs every 30 minutes? Do I add 1 line for 30 minutes, then anouther for 60 and so on?

Thanks for you quick response.

 

[SteveO59L]

Application.OnTime Now + TimeValue("00:30:00"), "my_Procedure"

will run the procedure every 30 minutes

 

[mroseto]

Ok, sorry for so many questions, but where does this go? In "This workbook" or in Module1?

Thanks again