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---

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

--
Regards,
Tom Ogilvy

"CDotWin" wrote in message
...

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---

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.

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

--
Regards,
Tom Ogilvy

"CDotWin" wrote in
message
...

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---


.

Try adapting the code shown at
http://www.mrexcel.com/archive/Controls/31950.html


"CDotWin" wrote in message
...

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---