Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
status indicator on screen
how do I display a text (?) box on the screen which can show different
captions while code continues to run in the background ex; the box might have the following sequence of captions "determining number of records", "retrieving records", "updating report", "reformatting to new settings"... (where all of these captions are 'descriptions' for the section of code that is currently being executed thanks in advance mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
status indicator on screen
Put up a userform
display it modeless. Modeless operation only officially supported in xl2000 and later. -- Regards, Tom Ogilvy "mark kubicki" wrote in message ... how do I display a text (?) box on the screen which can show different captions while code continues to run in the background ex; the box might have the following sequence of captions "determining number of records", "retrieving records", "updating report", "reformatting to new settings"... (where all of these captions are 'descriptions' for the section of code that is currently being executed thanks in advance mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
status indicator on screen
Mark, one way is to put it in the status bar at the bottom, like this
Application.StatusBar = "determining number of records" don't forget to set it to Application.StatusBar = "" at the end. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "mark kubicki" wrote in message ... how do I display a text (?) box on the screen which can show different captions while code continues to run in the background ex; the box might have the following sequence of captions "determining number of records", "retrieving records", "updating report", "reformatting to new settings"... (where all of these captions are 'descriptions' for the section of code that is currently being executed thanks in advance mark |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
status indicator on screen
Mark,
There's a ready built version he http://www.enhanceddatasystems.com/E...rogressBar.htm Robin Hammond www.enhanceddatasystems.com "mark kubicki" wrote in message ... how do I display a text (?) box on the screen which can show different captions while code continues to run in the background ex; the box might have the following sequence of captions "determining number of records", "retrieving records", "updating report", "reformatting to new settings"... (where all of these captions are 'descriptions' for the section of code that is currently being executed thanks in advance mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Status bar disappears when restoring screen size | Excel Discussion (Misc queries) | |||
Shared workbook displays [version 1] in status indicator | Excel Discussion (Misc queries) | |||
The saving indicator and caps bar has disappeared fromthe screen | Excel Discussion (Misc queries) | |||
The saving indicator and caps bar has disappeared fromthe screen | Excel Discussion (Misc queries) | |||
macro status indicator | Excel Discussion (Misc queries) |