Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Status Message User Form in Excel '97
Hi all,
I've created a workbook in Excel 2000 that runs a series of functions (e.g. imports a file, manipulates the data, outputs a report, etc.). I wanted to present a custom status message to the end user to let her know what step is being processed. So, I put together the following code: Sub Update_StatRem(StatRem, ScreenUpdate) UserForm2.lblStatRem.Caption = StatRem Application.ScreenUpdating = True UserForm2.Show (vbModeless) UserForm2.Repaint Application.ScreenUpdating = ScreenUpdate End Sub In this case, StatRem is a line of text, like "Importing the file..." that I pass from the calling macro to this macro. Each time a new step is started in the series of macros, I pass a new value to StatRem, call this code, and the userform is updated with a new message. The problem is some end users are using Office '97 and Office '97 can't run a userform as modeless. Is there a way to make this work in both Office '97 and Office 2000? If not, is there a way to accomplish my goal in just Office '97? Thanks in advance for the help. -Brad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minus Key Results in EXT Message in Status Bar | Excel Discussion (Misc queries) | |||
Why do I have a permanent Calculate message in the Status Bar? | Excel Discussion (Misc queries) | |||
Calculating Cells n% message in Status bar | Excel Discussion (Misc queries) | |||
calculate message in status bar | Excel Discussion (Misc queries) | |||
'Calculate' message at the status bar | Excel Programming |