Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In other posts I have seen that the status bar has been suggested as the
prefered way to show macro progress... The VBA that I am running swiches between several workbooks and with Screen updating turned off, the WB that is open when the macro starts... is not the one that has focus(in the background) where the status bar would display (if it even would show changes with screen updating off). what would be a good way to have the current section being executed always show? I'd like to have a msgbox popup for this, but I dont want the "OK" button to sit there a wait for a press. Is there some way to define a seperate box or form that can display the status message? Will I have to toggle screen updating on to show it, then toggle it back off? and, I assume that I would have to swap the active workbook.worksheet to make sure it has the focus. suggestions? -- Regards, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MS Progress Indicator Mimicked. Thank you. | Excel Programming | |||
Mimick MS Progress Indicator? | Excel Programming | |||
UserForm as Progress Indicator | Excel Programming | |||
PROGRESS INDICATOR | Excel Programming | |||
Popup Progress Indicator | Excel Programming |