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

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

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

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