Userform shadows...

  • Thread starter Thread starter RJH
  • Start date Start date
R

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
 
RJH,

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

hth,

Doug
 
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
 
Thanks to both!
I shut down screen updating to hide the "screen bounce" during the macro's
execution.

RJH
 
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.
 
Back
Top