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

Thread: Close userform with a button.

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

    Default

    probably a simple one but I can`t find the right sytax for this. I want a button on my userform to close it.

    What is the syntax for this?


    Private Sub CommandButton3_Click()

    UserForm1.Close, exit? HOW?

    End Sub

    Thanks people.

  2. #2
    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

    Unload Me

  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

    or...

    Unload Userform1

    Space with no period

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Tom.

    Is there any way of findings these things out without having to go on a course or something like that?

    I try to find out simple things like this myself first before asking them here but
    I could not find this in any help file.

  5. #5
    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

    The absolute best way to learn is in VB help
    The first thing new programmers need to learn is how to use the helps provided.

    Books are great!

    When you are stuck this board is great!

    Have fun programming!!!

    If you have trouble, come here or you can keep my E-mail
    I'll help you if I can

    tstom@hotmail.com

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I really can`t believe how helpfull people on this forum are. Yesterday audiojoe just mailed me a piece of programme in an instant and you are also real helpful.

    *APPRECIATION*

    And I`ll do my best to follow this behaviour.

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
  •