Timer???

[charlie79]

Is it possible to have a timer event in an excel application to refresh the worksheet?

 

[Dave Hawley]

Do you mean Calculate? If so have a look at the Application.OnTime method in VBA.

 

[charlie79]

Sorry, a little unclear. Yes, I need for my excel app to calculate entire sheet every, say 5 mins, this app will be open more then not and a refresh (or recalculate) is essential to the purpose. Ideas?

 

[Dave Hawley]

Hi Charlie

In a standard module (alt+F11 Insert>Module) put:

Sub StartOff()
Application.OnTime Now + "00:05:00", "StartOff"
Application.Calculate
Run "StartOff"
End Sub



In the Workbook module (right click on Excel icon left of "File", select "view Code" put:

Private Sub Workbook_Open()
Run "StartOff"
End Sub

 

[charlie79]

Thanks a bunch Dave...