Hi Andy
If MsgBox("Are you sure you want to do this?", vbYesNo + vbsuestion, "Please
confirm") = vbNo Then Exit Sub
MsgBox "not cancelled"
'do your stuff
To prevent closing your form add this into the form's code:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode < 1 Then Cancel = 1
End Sub
HTH
Cordially
Pascal
"bigandyt " a écrit dans le
message de ...
i was wondering if it is possible to insert vb code in a macro that will
display to the user "are u sure u want to do this" or along those
lines, if yes the rest of the macro is executed else the macro stops.
also i want to get rid of the 'X' at the top right of my form so the
user cannot close the form is this possible
any help would be appreciated
Andy
---
Message posted from http://www.ExcelForum.com/