Userform close button

[MartinST]

I have a UserForm that the user can select certain option buttons. If the user press the UserForm`s build in close button the UserForm will unload automatically without perform the pre-programmed actions.
How do you overcome that the user presses the build in close button, can this button be removed from the UserForm?

 

[VoG]

You can remove the X but this is simpler. In the userform's code module

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
    Cancel = True
    MsgBox "Click on a button to close!"
End If
End Sub

 

[MartinST]

Thanks VoG, that does the trick and has opened more possibilities for my limited programming skills!