Cancel button on userform

[KCIWebMaster]

I've got my form and macros working now (thanks to Richie for his help). ray:

My only problem now is that when you click on the cancel button on the form it still runs the macro before it closes the form. Where do I need to put the code for the cancel command button? Right now it's under forms but the code that calls up the form is in a macro in a module and I have a button on the spreadsheet that runs the macro and user form.

 

[ataloss]

You are awesome!!!! After weeks of trying and trying it finally works! Thank you so much!

 

[avinash_b]

Iam getting an error "Runtime error 361 / Application defined or object defined error"

 

[avinash_b]

Getting " runtime error 361 Cant load or unload this object."

 

[Rick Rothstein]

Getting " runtime error 361 Cant load or unload this object."

Which code are you using?

On which line of code did the error occur?

 

[avinash_b]

It occured to the cancel button code. I am using VBA code.

Private Sub CommandButton_Click()
Unload Me
End Sub

 

[avinash_b]

If it's clicked the code will run. If it's not clicked, it won't. Therefore you don't have to 'check' if it was clicked per se, the code will do it for you.
Private Sub CommandButton1_Click()
unload me
end
End Sub

Iam Getting an Error 361: Application defined or object defined error.