Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Userform Close Button

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

    Default

    So do you know the answer then Joe

    Thx
    Roy

  2. #12
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Nope. I only know about 9 things, so I get very excited when I think I might be able to help someone. They are as follows:

    Message Boxes
    Drawing a Userform
    Changing the font of your writing
    Changing the colour of your writing
    Changing the background of your excel page
    Saving your workbook
    How to write in a cell
    How to call the Office Wizard
    and
    Where to find excel on your start bar

    You never know, you might get stumped on one of those one day, but probably only if you take some bad LSD and it makes you lose your memory.

    Hold on, I'll try and get the answer for you....

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

    Default

    Come on Joe wheres the answer, or are you still busy petting that dog ( are you sure you are not hanging out of it).

    Thx
    Roy

  4. #14
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    So you've seen my ex-girlfriend?

    The answer is you have to set cancel to true within the userform_queryclose event.

    Now go and update your two year old screen name whilst I attempt the kiss of life on a horse. Whoops, wrong end...

  5. #15
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey Roy, told you I'd get there. Try this little baby:

    Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    If CloseMode = vbFormControlMenu Then
    Cancel = True
    Me.Caption = "Click the CommandButton to close Me!"
    End If
    End Sub

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
  •