Continouse Calc while userform is shown
There is no difference between the methods 1 and 2 - you would use method 1
to do method 2, so looks like you are set.
However, if calculation is set to automatic, there is not reason to do
anything else. If a change is made that requires calculation, calculation
will occur. The only reason I could think of to do what you describe is to
either update links or use the worksheet as a clock.
--
Regards,
Tom Ogilvy
"ExcelMonkey" wrote in message
...
Is there anyway to have Excel via VBA do a repetitive calc while a
userform
is showing? So when I say:
Userform.Show
I want to mimic what would happen if I held down the F9 key. Now this
could
either be based on:
1) a Loop with a timer
2) or it could be continous (triggered after the .show Method) and
disabled
when I press a command button on the shown userform.
Any ideas?
Thanks
EM
|