How can I run a function periodically in a visual basic form

[ii128]

How can I run a function periodically in a visual basic form without open and run the form?

 

[ratman]

Sub DoSomethingWhenToldTo()
Application.OnTime earliesttime:=TimeValue("23:58:00&quot, procedure:="macronamegoeshere"
End Sub


then possibly in your macro turn off events?

Application.EnableEvents=False

I never tried it.

 

[IonelBurtan]

You can use a Timer Object. Put it on your form and treat the timer event.

s-) Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...

http://home.domaindlx.com/ionelb