Best way to create Splash Screen?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Best way to create Splash Screen?

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    97
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'm creating an app that processes a lot of calculations onOpen. For this reason, I want to present users with a splash screen that indicates there are processes running and to wait. I don't want the user to be able to close this splah screen (or userform). Making it modal doesn't seem to work, my code after the userform.show doesn't execute, even using doevents. Any ideas?

    [ This Message was edited by: charlie79 on 2002-02-28 11:28 ]

    [ This Message was edited by: charlie79 on 2002-02-28 11:29 ]

  2. #2
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Once the userform is visible it has priority so everything else is put on hold until it is closed. To get around this you can put only the userform.show in the workbook_open event then run all the other code from the userform.activate sub then close the userform when you are done. Another option is to make a certain sheet visible when the code is running this sheet could have your splashscreen info. Or you can use the statusbar.

    HTH

    DRJ


  3. #3
    Board Regular Bruno's Avatar
    Join Date
    Feb 2002
    Posts
    480
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Charlie,
    another solution :
    - create an userform without OK buttons
    - use labels or other controls to inform th e user
    - use MyUserform.show to show the form ( obvious )
    - use Private Sub UserForm_Activate() and place all your code here, ending with Unload MyUserForm


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com