worksheet_change / userform close

[James]

Is it possible to close a userform when you
go to another worksheet?

James

 

[Bucki]

Hi

Didn't want to open new topic
as my question has to do with close user form and thought to ask here!

I use this code:

Private Sub cmdClose_Click()
Unload Me
End Sub

How would add some code, to actually say
"Are you sure you want to close" Yes / NO
when clicking CLOSE button

Thanks

 

[meldoc]

Hello

Maybe something like this.

Private Sub cmdClose_Click()
    Dim ans As Integer
    ans = MsgBox("Are you sure you want to close ", vbYesNo)
    If ans = vbNo Then Exit Sub
Unload Me
End Sub

 

[Bucki]

HAH :D

That code works as a charm.

Cheers Mate