What is needed in VBA to unload a form from the screen
when I click the cancel button?

Thanks in advance

Edward

Hi edward

A macro with this line
Unload Me

More info on this page
http://support.microsoft.com/default...b;EN-US;829070


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Edward" wrote in message ...
What is needed in VBA to unload a form from the screen
when I click the cancel button?

Thanks in advance

Edward

A simple way is to put this line in your button's code:

Private Sub CommandButton1_Click()
Unload Me
End Sub



Edward Wrote:
What is needed in VBA to unload a form from the screen
when I click the cancel button?

Thanks in advance

Edwar

--
madblok
-----------------------------------------------------------------------
madbloke's Profile: http://www.excelforum.com/member.php...fo&userid=1442
View this thread: http://www.excelforum.com/showthread.php?threadid=26511