Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
progress bar second question
this refers to my earlier post about a progress bar, it seems that its
a no-no, so how would i go about displaying a message that just says some info i.e loading but disapears once the word doc is open, I know how to display userforms and message boxes but the problem is that the excel is programmed to shut down once the code for loading the word doc has run, so i can get a message displayed until the word doc opens then my excel shuts down. regards Johny5 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
progress bar second question
Application.StatusBar = "Opening Word File, Please Wait"
' code to open word file Application.StatusBar = False Another possibility is to show a modeless userform if using Excel 2000 or later userform1.Show vbModeless ' code to open word file Unload Userform1 for tighter control you could show a modal userform and in the Activate event of the userform, open the word.doc. Then unload the form. These all assume you are opening the word document with automation and not using the shell command. -- Regards, Tom Ogilvy wrote in message oups.com... this refers to my earlier post about a progress bar, it seems that its a no-no, so how would i go about displaying a message that just says some info i.e loading but disapears once the word doc is open, I know how to display userforms and message boxes but the problem is that the excel is programmed to shut down once the code for loading the word doc has run, so i can get a message displayed until the word doc opens then my excel shuts down. regards Johny5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Progress Bar | Excel Discussion (Misc queries) | |||
Progress bar | Excel Discussion (Misc queries) | |||
Progress YTD | Charts and Charting in Excel | |||
Progress Bar | Excel Programming | |||
Progress Bar Help | Excel Programming |