Code for a progress dialog??
 

I'm fairly new at writing macros in Excel, but I have some code that
runs for a while and I would like to display something that tells the
user that there's something going on and they need to wait. I'm using
Excel '97 so that may cause some problems. Right now I'm displaying a
message in the Status bar, but something more visible would be better.


Also, can anyone tell me why it takes so long for code to run when I
use VB to fill a page header??

Thanks in advance!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Code for a progress dialog??
 

Take a look at John Walkenbach's site
http://j-walk.com/ss/excel/tips/tip34.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"lifter10101010" wrote in
message ...

I'm fairly new at writing macros in Excel, but I have some code that
runs for a while and I would like to display something that tells the
user that there's something going on and they need to wait. I'm using
Excel '97 so that may cause some problems. Right now I'm displaying a
message in the Status bar, but something more visible would be better.


Also, can anyone tell me why it takes so long for code to run when I
use VB to fill a page header??

Thanks in advance!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Code for a progress dialog??
 

Thanks!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/