Disappearing Userform Label

D

donbowyer

Excel 2003 on Win XP
I want to display to the user of a complex UserForm a <<Please Wait>>
message while a macro with long iteration loops runs.
I've tried adding a Label with appropriate words to the UserForm, by adding
code to the macro making it Visible.True at the start of the routine and
Visible.False at the end.
If I step thru the macro it works as expected, but when it is run normally,
the message / label never appears.
Why might this be??
 
J

Jim Cone

You could try...
Me.Repaint
....immediately after making the label visible.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"donbowyer"
wrote in message
Excel 2003 on Win XP
I want to display to the user of a complex UserForm a <<Please Wait>>
message while a macro with long iteration loops runs.
I've tried adding a Label with appropriate words to the UserForm, by adding
code to the macro making it Visible.True at the start of the routine and
Visible.False at the end.
If I step thru the macro it works as expected, but when it is run normally,
the message / label never appears.
Why might this be??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Must something be done to a userform? 2
Routine too fast for Form to Update? 1
Errors Closing Userform 0
pass a variable to activate 4
userform property change race 2
VBE tricky question 2
blank userform 3
Read text from table in a document, place it in a userform label,then delete the table 2

Top