Userform Close Button

[RoyinUK2000]

Is it possible to stop a user shutting a userform with the close button.

Thx
Roy

 

[RoyinUK2000]

So do you know the answer then Joe

Thx
Roy

 

[Audiojoe]

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

 

[RoyinUK2000]

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

 

[Audiojoe]

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

 

[Audiojoe]

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