Userform shadows...

[RJH]

I have a sheet (Excel 2003, XP Home) that uses several user forms.
The user forms appear at the start of the macro and as each one disappears
for the next a shadow is left.
Also if I drag the forms they leave a 'tail' of forms behind. The shadows
and tails disappear if OK or CANCEL
are clicked but why does this happen?

Thanks!

RJH

 

[Doug Glancy]

RJH,

You need to set Application.ScreenUpdating = True before you call the form.

hth,

Doug

 

[Jim Cone]

You need to turn on ScreenUpdating before showing the form.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


I have a sheet (Excel 2003, XP Home) that uses several user forms.
The user forms appear at the start of the macro and as each one disappears
for the next a shadow is left.
Also if I drag the forms they leave a 'tail' of forms behind. The shadows
and tails disappear if OK or CANCEL
are clicked but why does this happen?
Thanks!
RJH

 

[RJH]

Thanks to both!
I shut down screen updating to hide the "screen bounce" during the macro's
execution.

RJH

 

[Tom Ogilvy]

You need to learn to program without selecting and activating. In most
cases these activities are not required. Look at most of the code in this
group for examples.

 

[RJH]

Thanks for the tip Tom.
I'm still pretty green at this!

RJH