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

RJH,

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

hth,

Doug


"RJH" <[email protected]> wrote in message
news:[email protected]...
>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
>

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


"RJH" <[email protected]> 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

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

RJH


"Jim Cone" <[email protected]> wrote in message
news:[email protected]...
> You need to turn on ScreenUpdating before showing the form.
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
>
>
> "RJH" <[email protected]> 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
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> Thanks to both!
> I shut down screen updating to hide the "screen bounce" during the macro's
> execution.
>
> RJH
>
>
> "Jim Cone" <[email protected]> wrote in message
> news:[email protected]...
> > You need to turn on ScreenUpdating before showing the form.
> > --
> > Jim Cone
> > San Francisco, USA
> > http://www.realezsites.com/bus/primitivesoftware
> >
> >
> > "RJH" <[email protected]> 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
> >
> >
>
>

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

RJH

"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> Thanks to both!
>> I shut down screen updating to hide the "screen bounce" during the
>> macro's
>> execution.
>>
>> RJH
>>
>>
>> "Jim Cone" <[email protected]> wrote in message
>> news:[email protected]...
>> > You need to turn on ScreenUpdating before showing the form.
>> > --
>> > Jim Cone
>> > San Francisco, USA
>> > http://www.realezsites.com/bus/primitivesoftware
>> >
>> >
>> > "RJH" <[email protected]> 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
>> >
>> >
>>
>>
>
>