How to unload a form
 

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

How to unload a form
 

On the click event of the cancel button:

Unload Me

--

Hope that helps.

Vergel Adriano


"Grd" wrote:

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

How to unload a form
 

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

On Mar 20, 3:40 pm, Grd wrote:
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

How to unload a form
 

thats it, thanks
suzanne

"Vergel Adriano" wrote:

On the click event of the cancel button:

Unload Me

--

Hope that helps.

Vergel Adriano


"Grd" wrote:

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