I have a formulas that I need to continually calculate every 5 secs, until
something is clicked to pause it.

I'm assuming I need two macros, one that would be loop calculate, and the
second to pause the calculate.

Any assistance on the macros i need to use would be great

Thanks,
Kim

See Chip Pearson's site for OnTime code.

http://www.cpearson.com/excel/OnTime.aspx


Gord Dibben MS Excel MVP

On Sun, 10 Jan 2010 18:03:01 -0800, KimC
wrote:

I have a formulas that I need to continually calculate every 5 secs, until
something is clicked to pause it.

I'm assuming I need two macros, one that would be loop calculate, and the
second to pause the calculate.

Any assistance on the macros i need to use would be great

Thanks,
Kim