+ Reply to Thread
Results 1 to 6 of 6

Userform shadows...

  1. #1
    RJH
    Guest

    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



  2. #2
    Doug Glancy
    Guest

    Re: Userform shadows...

    RJH,

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

    hth,

    Doug


    "RJH" <Bla@bla.net> wrote in message
    news:Kyi0g.29113$cY3.11719@news-wrt-01.rdc-nyc.rr.com...
    >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
    >




  3. #3
    Jim Cone
    Guest

    Re: Userform shadows...

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


    "RJH" <Bla@bla.net> 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



  4. #4
    RJH
    Guest

    Re: Userform shadows...

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

    RJH


    "Jim Cone" <jim.coneXXX@rcn.comXXX> wrote in message
    news:OdensbQYGHA.2148@TK2MSFTNGP02.phx.gbl...
    > You need to turn on ScreenUpdating before showing the form.
    > --
    > Jim Cone
    > San Francisco, USA
    > http://www.realezsites.com/bus/primitivesoftware
    >
    >
    > "RJH" <Bla@bla.net> 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
    >
    >




  5. #5
    Tom Ogilvy
    Guest

    Re: 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" <Bla@bla.net> wrote in message
    news:Zcj0g.32798$x97.2306@news-wrt-01.rdc-nyc.rr.com...
    > Thanks to both!
    > I shut down screen updating to hide the "screen bounce" during the macro's
    > execution.
    >
    > RJH
    >
    >
    > "Jim Cone" <jim.coneXXX@rcn.comXXX> wrote in message
    > news:OdensbQYGHA.2148@TK2MSFTNGP02.phx.gbl...
    > > You need to turn on ScreenUpdating before showing the form.
    > > --
    > > Jim Cone
    > > San Francisco, USA
    > > http://www.realezsites.com/bus/primitivesoftware
    > >
    > >
    > > "RJH" <Bla@bla.net> 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
    > >
    > >

    >
    >




  6. #6
    RJH
    Guest

    Re: Userform shadows...

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

    RJH

    "Tom Ogilvy" <twogilvy@msn.com> wrote in message
    news:uj60k3VYGHA.4168@TK2MSFTNGP05.phx.gbl...
    > 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" <Bla@bla.net> wrote in message
    > news:Zcj0g.32798$x97.2306@news-wrt-01.rdc-nyc.rr.com...
    >> Thanks to both!
    >> I shut down screen updating to hide the "screen bounce" during the
    >> macro's
    >> execution.
    >>
    >> RJH
    >>
    >>
    >> "Jim Cone" <jim.coneXXX@rcn.comXXX> wrote in message
    >> news:OdensbQYGHA.2148@TK2MSFTNGP02.phx.gbl...
    >> > You need to turn on ScreenUpdating before showing the form.
    >> > --
    >> > Jim Cone
    >> > San Francisco, USA
    >> > http://www.realezsites.com/bus/primitivesoftware
    >> >
    >> >
    >> > "RJH" <Bla@bla.net> 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
    >> >
    >> >

    >>
    >>

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1