This example runs my_Procedure at 5 P.M.Īpplication.OnTime TimeValue("17:00:00"), "my_Procedure" Sample Code: Option Explicit Sub ScheduleAMacro() Application.OnTime Now + TimeSerial(0, 1, 0), "AlarmMacro" End Sub 'This should be the macro that runs after one minute 'We simply pops up a message box. The Application.OnTime method can make macros run automatically, once youve done some. You can configure an event in Excel to run a given macro at a set time with the Application.OnTime method: In VBAProject at add the following code: Private Sub WorkbookOpen() Application. Click the command button on the worksheet. Fortunately, Excel provides a VBA method that makes this possible. This example runs my_Procedure 15 seconds from now.Īpplication.OnTime Now + TimeValue("00:00:15"), "my_Procedure" 2. Application.OnTime Now() + TimeValue(" 00:00:05" ), " reminder".
We used Now + TimeValue(time) in our example to schedule something to be run when a specific amount of time (counting from now) has elapsed as TimeValue(time) is used to schedule something to be run a specific time.įor e.g. Coming to our topic, we're actually gonna discuss Application.OnTime Object of Application class.įor details: Please visit Microsoft MSDN here: (office.11).aspx Heylo, How is your office life going on? I pray for all of you and wish you lots of wealth and a very good health.
0 kommentar(er)
