Progress Bar with Timer

C

CDotWin

Please Help

I am trying to run a progress bar while VB is performing it's procedures to let the user know the worksheet is calculating. I can not find the timer in Excel VB 97. I want the progress bar to simply move back and forth.

Thanks in Advance
---CDotWin---
 
T

Tom Ogilvy

code won't be running while the sheet is calculating. Excel isn't
multitasking.

--
Regards,
Tom Ogilvy

CDotWin said:
Please Help

I am trying to run a progress bar while VB is performing it's procedures
Click to expand...
to let the user know the worksheet is calculating. I can not find the timer
in Excel VB 97. I want the progress bar to simply move back and forth.
 
G

Guest

I just change the status bar to say WORKING and then
freeze the panes until it's done, then unfreeze and reset
the status bar.
 
Top