Close userform with a button.

Dinictus · Mar 22nd, 2002, 03:11 AM

probably a simple one but I can`t find the right sytax for this. I want a button on my userform to close it.

What is the syntax for this?

Private Sub CommandButton3_Click()

UserForm1.Close, exit? HOW?

End Sub

Thanks people.

Tom Schreiner · Mar 22nd, 2002, 03:13 AM

Unload Me

Tom Schreiner · Mar 22nd, 2002, 03:16 AM

or...

Unload Userform1

Space with no period

Dinictus · Mar 22nd, 2002, 03:18 AM

Thanks Tom.

Is there any way of findings these things out without having to go on a course or something like that?

I try to find out simple things like this myself first before asking them here but
I could not find this in any help file.

Tom Schreiner · Mar 22nd, 2002, 03:26 AM

The absolute best way to learn is in VB help
The first thing new programmers need to learn is how to use the helps provided.

Books are great!

When you are stuck this board is great!

Have fun programming!!!

If you have trouble, come here or you can keep my E-mail
I'll help you if I can

tstom@hotmail.com

Dinictus · Mar 22nd, 2002, 03:31 AM

I really can`t believe how helpfull people on this forum are. Yesterday audiojoe just mailed me a piece of programme in an instant and you are also real helpful.

*APPRECIATION*

And I`ll do my best to follow this behaviour.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 03:11 AM	#1
Dinictus Board Regular Join Date: Mar 2002 Posts: 162	probably a simple one but I can`t find the right sytax for this. I want a button on my userform to close it. What is the syntax for this? Private Sub CommandButton3_Click() UserForm1.Close, exit? HOW? End Sub Thanks people.

Mar 22nd, 2002, 03:13 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Unload Me

Mar 22nd, 2002, 03:16 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	or... Unload Userform1 Space with no period

Mar 22nd, 2002, 03:18 AM	#4
Dinictus Board Regular Join Date: Mar 2002 Posts: 162	Thanks Tom. Is there any way of findings these things out without having to go on a course or something like that? I try to find out simple things like this myself first before asking them here but I could not find this in any help file.

Mar 22nd, 2002, 03:26 AM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	The absolute best way to learn is in VB help The first thing new programmers need to learn is how to use the helps provided. Books are great! When you are stuck this board is great! Have fun programming!!! If you have trouble, come here or you can keep my E-mail I'll help you if I can tstom@hotmail.com

Mar 22nd, 2002, 03:31 AM	#6
Dinictus Board Regular Join Date: Mar 2002 Posts: 162	I really can`t believe how helpfull people on this forum are. Yesterday audiojoe just mailed me a piece of programme in an instant and you are also real helpful. APPRECIATION And I`ll do my best to follow this behaviour.