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??

--
donwb

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??
--
donwb

Hi Jim
Many thanks for the response.
I'd forgotten all about Repaint!
--
donwb


"Jim Cone" wrote:


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??
--
donwb