Help with Userforms

[Panagiotis Marantos]

Hello

just a quick question about userforms.

i want to disable the close button on the top right

how can i do that???

 

[Tom Hutchins]

Add the macro below to the userform code module:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
MsgBox "You can't close the dialog like this!"
End If
End Sub

Here is where I got that code:
http://www.erlandsendata.no/english/index.php?d=envbadialogspreventclose

Hope this helps,

Hutch

 

[Panagiotis Marantos]

that works perfect

thanks for that

i was trying to find something in the userform porperties similarly to the
access forms properties.

never though to prevent by code