How to unload a form

[Guest]

Hi everyone

I have a form in Excel VBA and I need it to unload when I hit the cancel
button. I tried several things and none seem to work properly.

Can anyone help me?

Thanks in advance

Suzanne

 

[Guest]

On the click event of the cancel button:

Unload Me

 

[paul.robinson]

Hi
double click the Cancel button inside the Editor and you get

Private Sub Button1_Click()

End sub

or similar. Change this to

Private Sub Button1_Click()
Unload Me
End sub

regards
Paul

 

[Guest]

thats it, thanks
suzanne

On the click event of the cancel button:

Unload Me

--

Hope that helps.

Vergel Adriano