Userform shadows...
 

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

Userform shadows...
 

RJH,

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

hth,

Doug


"RJH" wrote in message
...
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

Userform shadows...
 

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


"RJH" wrote in message
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

Userform shadows...
 

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

RJH


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


"RJH" wrote in message
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

Userform shadows...
 

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.

--
Regards,
Tom Ogilvy


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

RJH


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


"RJH" wrote in message
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

Userform shadows...
 

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

RJH

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy


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

RJH


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


"RJH" wrote in message
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