Clearing off forms

Audiojoe · Feb 28th, 2002, 06:36 AM

Hi, I'm pretty new to VBA and am currently making a userform. When I click a button at the bottom of my form to submit the info another form comes up saying would I like to go to another form, but if I say yes, the little form that asks me that stays there. I need it to disappear once it's done it's job.

How do I do this?

[ This Message was edited by: Audiojoe on 2002-02-28 05:37 ]

Mudface · Feb 28th, 2002, 06:41 AM

In the button's Click event, put this at the end-

Private Sub CommandButton1_Click()

UserForm2.Show
Me.Hide

End Sub

Audiojoe · Feb 28th, 2002, 06:44 AM

Superb! Thanks man

Mudface · Feb 28th, 2002, 06:49 AM

Actually that should be-

Me.Hide
UserForm2.Show

Sorry

Audiojoe · Feb 28th, 2002, 07:31 AM

Ah yes, that's better

Audiojoe · Feb 28th, 2002, 07:31 AM

Ah yes, that's better

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

Feb 28th, 2002, 06:36 AM	#1
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Hi, I'm pretty new to VBA and am currently making a userform. When I click a button at the bottom of my form to submit the info another form comes up saying would I like to go to another form, but if I say yes, the little form that asks me that stays there. I need it to disappear once it's done it's job. How do I do this? [ This Message was edited by: Audiojoe on 2002-02-28 05:37 ]

Feb 28th, 2002, 06:41 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	In the button's Click event, put this at the end- Private Sub CommandButton1_Click() UserForm2.Show Me.Hide End Sub

Feb 28th, 2002, 06:44 AM	#3
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Superb! Thanks man

Feb 28th, 2002, 06:49 AM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Actually that should be- Me.Hide UserForm2.Show Sorry

Feb 28th, 2002, 07:31 AM	#5
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Ah yes, that's better