OnTime method: Setting arguments in called procedures

[jc113883]

Hi all,

You can use the OnTime macro to run procedures at certain times:

 Application.OnTime "07:30", "MyProcedure"

But how do I set the arguments that MyProcedure requires to run?

For example, I have a procedure:

 Sub MyProcedure (Arg1)
 a = Arg1
 End Sub

Lets say I want Arg1 = 2. The following do not work:

Application.OnTime "07:30", "MyProcedure(2)"     '(Can't find 'MyProcedure(2)'
Application.OnTime "07:30", "MyProcedure" (2)      'Syntax Error

So does anyone know what does?!

Cheers,
Graeme.

 

[tusharm]

Using procedures with arguments in non-obvious instances:
macros associated with shapes, forms, and commandbar elements, and called by the OnTime and OnKey methods
http://www.tushar-mehta.com/excel/vba/xl objects and procedures with arguments.htm

 

[hsk]

one sugg ..... u can use "call"

Application.OnTime "07:30", "tempPro"

Sub tempPro ()
call MyProcedure (2)
End Sub

 

[jc113883]

Thanks TusharM, Very informative.

 

[tusharm]

You are welcome.

Thanks TusharM, Very informative.