Hei!

When pushing F9-key on the keyboard, the excel-sheet is being calculated (run). But what are the code behind the F9-key?

Mvh
grstad

__________________
Internet has become favorable with that tool...thank you Tim Berners-Lee!

The vb command executed is Calculate


Often I use ActiveSheet.Calculate to control calculation

the following sets the workbook to manual calculation
Application.Calculation = xlManual
Application.CalculateBeforeSave = False


DG

...ok and thank you DaveJoyG. Can you explain the different objects and methods or the different parts of the code? Is it Visual Basic? I have only basic knowledge in VBScript (ASP)...

I have realised that it is the internal clock of the pc that actually are running. If I return the Win-time in a cell, it shows the digits corresponding to the current time. And I can see the time running, showing up to 18 digits or more. (In other words; the prosessor-speed?)

I would like to use that in a VBScript (ASP-tech), but I guess it is a mutch more simple way to control time in VBScript?

Mvh
grstad

I.m not sure I'm following your question.
When F9 is pressed, a new calculation is forced on the worksheet. The vb command for that is Calculate. Excel normally is defaulted to auto-calculation and will re-calculate the sheet anytime changes are made to affected formulas. I believe it is a worksheet change event that triggers this.
Not sure what you mean by the clock of the PC since time is not really involved. If you have =Now() in a cell then the time will refresh to the current system time each time F9 is pressed.
Are you looking to execute an event based on time?
You can use:
                Application.OnTime Now + TimeValue("00:00:15"), "my_Procedure"
or Application.OnTime TimeValue("17:00:00"), "my_Procedure"

Hope this helps...

DaveG