Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    'Please wait' screen (WinNT/Word97)

    I have a template that takes a little while to set itself up (around 10-15 seconds, depending on the machine), and I'd like to have a small screen come up that basically just says "Please wait, we'll get there in a sec" and goes away when the template is ready to go.

    I've tried a msgbox (can't get it to go away without user clicking OK button or similar) and a userform (again, just sits there; in fact template won't continue until user clicks on X in corner!)!

    I'm sure there must be a way to do this ... does anyone have any suggestions, please?

    Ta muchly!
    Beryl M


  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Please wait' screen (WinNT/Word97)

    Use the userforms Activate event to fire the rest of the initialisation routine. If that's finished, unload the form, see attached.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: 'Please wait' screen (WinNT/Word97)

    Thanks for that! Looks like it should be perfect ... <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Beryl M


  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: 'Please wait' screen (WinNT/Word97)

    Life gets easier starting with Office 2000, since VBA 6.x supports nonmodal user forms...

Posting Permissions

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