Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for a progress dialog??
Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to display the "Find" (Ctrl+F) dialog box | Excel Programming | |||
VBA code to invoke the Print dialog box. | Excel Programming | |||
VBA code to make a progress tool bar work | Excel Programming | |||
Code to display dialog for unhiding sheets | Excel Programming | |||
Code to display dialog for unhiding sheets | Excel Programming |