Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Timed Userforms

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Nashua NH
    Posts
    164
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Y'all. Great website. Very informative. Quick question: How do I get a userform to appear at startup of a particular worksheet, and then shut itself off? (Using it simply as an introduction) Also, is there a way to eliminate the top banner of the userform, thus eliminating the X in the right corner, and/or replacing it with min/ max buttons instead?
    Been searching and haven't found the answer here yet. Thanx in advance for the help!

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On the userform Initialze event, stick in an Application.Wait command then put "Unload Me" after it.

    Min and Max:

    http://www.mrexcel.com/board/viewtop...c=1005&forum=2

    Disable Close Button is on this board (it is possible to remove is as well), but I need to get outta here, so I can't find it just now.


    HTH


  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    For your first question...

    Private Sub UserForm_Activate()
    Dim Start
    Start = Timer + 2
    Do While Timer < Start
    DoEvents
    Loop
    Unload Me
    End Sub
    Will display the form for 2 seconds and will then unload the userform...

    Tom

    Didn't mean to over post you Mark...


    [ This Message was edited by: TsTom on 2002-04-25 13:19 ]

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Nashua NH
    Posts
    164
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanx for the help. I managed to make something up on the timed event. But I am going to try yours, Tom.
    As for the min/max, that may be a bit much for me to digest just yet. Thanx all.

Some videos you may like

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
  •