A
Aaron Russell
is there anyway to get excel to constantly act like f9 is being pressed?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jamie
Click on Tools, Options, then under Calculations, select Automatic
C
CarlosAntenna
tools/options/calculation/automatic
A
Aaron Russell
anyway to do it faster. I would like it so it acts like f9 is being pressed
every second.
every second.
D
Don Guillett
why?
J
Jamie
Do you want Excel to automatically calculate formulas? In otherwords, when
you type in a new value, your formula gives you a new result?
If so, then that's what the Automatic option does for you.
Otherwise, maybe you could explain what your desired result is a little more
clearly.
J-me
you type in a new value, your formula gives you a new result?
If so, then that's what the Automatic option does for you.
Otherwise, maybe you could explain what your desired result is a little more
clearly.
J-me
A
Aaron Russell
I have a calculation that shows how many seconds it is until a current
date.. basically it's like a countdown. It shows how many seconds from
right now until december 31, 2004. I would like it to constantly countdown
while I have the spreadsheet open. If you need anymore details I'll post
them. thanks for all your replys.
date.. basically it's like a countdown. It shows how many seconds from
right now until december 31, 2004. I would like it to constantly countdown
while I have the spreadsheet open. If you need anymore details I'll post
them. thanks for all your replys.
H
Harald Staff
This is a macro. It has to run.
Sub RunClock()
If Cells(1, 1).Value <> "" Then Exit Sub
Application.Calculate
Application.OnTime (Now + 1 / 86400), "RunClock"
End Sub
It stops the second A1 is not empty.
HTH. Best wishes Harald
Sub RunClock()
If Cells(1, 1).Value <> "" Then Exit Sub
Application.Calculate
Application.OnTime (Now + 1 / 86400), "RunClock"
End Sub
It stops the second A1 is not empty.
HTH. Best wishes Harald