Automatic Updating of (based on a specified time period)

[Dancey_]

Hey guys,

I have been tasked with developing a leader board that will up on a big screen in my office at work.

I am able to get the data and need and present it correctly etc.

However, I am struggling to find the VBA Code to force the work book to calculate every x seconds. I think every 30s would be about right.

I am sure it is very simple, but I cannot find how to do it.

The automatic updating can be triggered manually at the beginning but it would need to continue after that on its own.

Please help me!?

Cheers

 

[VoG]

Take a look at the OnTime method http://www.ozgrid.com/Excel/run-macro-on-time.htm

 

[Dancey_]

Thanks for the info! No doubt I will be back when I cant make it work.

Cheers