Auto Calculate

**Smeeg** · 11-03-2006, 05:00 AM

Hi there,

I've created a spreadsheet which is counting down to when I go on holiday, but to update it I need to keep on pressing F9 (or by going to: Tools/Options/Calculation and then clicking on 'Calc Now (F9) ).

Is there a formula or macro I can use which automatically updates the spreadsheet continuosly so I can watch those seconds tick on by?

Many thanks,

AJ

**Carim** · 11-03-2006, 05:10 AM

Hi,

Have you had a go with Application.Ontime ?

Carim

**Smeeg** · 11-03-2006, 05:11 AM

Originally Posted by Carim

Hi,

Have you had a go with Application.Ontime ?

Carim

never heard of that, what is it? and how do I use it?

thanks.

AJ

**Carim** · 11-03-2006, 05:28 AM

Basically two macros are needed, for example a private event to launch the Ontime routine and the standard MyMacro which does the calculation ...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

HTH
Carim

**Smeeg** · 11-03-2006, 05:44 AM

Originally Posted by Carim

Basically two macros are needed, for example a private event to launch the Ontime routine and the standard MyMacro which does the calculation ...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

HTH
Carim

thanks for all this - it sounds like just the thing. The problem is I have no idea how to include this in my spreadsheet as I've not used Macro's or Visual Basic before.

Sorry to be a pain, but I don't suppose you could give me a step by step as to what to do?

I've included my spreadsheet as a zip file if that's any help.

Thanks again,

AJ