How do I close form

[Guest]

I am having problems closing a form. I am inexperiences with VB in excel but
have done quite a bit with access.
I am trying to use a form to get a password to unhide columns in a form. I
am using a command button on the worksheet to open a form called frmPassword.
I want to use the text in a txt box to set the value of a variable in the
original procedure that shows the frmPassword. I cannot however get the form
to close. I have put a command button on the form and am trying to use it's
click event to close the form - in access I would use me.close. This does not
become an option in the list available and if I type it I get an error
message that the method or data member was not found. I would be grateful for
any help

 

[Bob Phillips]

Me.Hide

This will hide but not unload the form, so the controls (and their values)
are still accessible.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Flanagan]

Use

Me.Hide

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Guest]

Mant thanks to you both that works fine

Use

Me.Hide

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel