VBA Help!!!

rstone25 · Mar 26th, 2002, 04:13 AM

Hi,

I have 2 worksheets - 1 has refreshing data and the other is a form with insturctions on how to use the form.

I have created a command button on my form which I want to start another Form (called Userform1 which was done in VBA) I have ripped most of the Module from another xls file and everything else works except this one button.

Does anyone know how to set it to load the main userform?

Dave Hawley · Mar 26th, 2002, 04:17 AM

To load and show it use:

Private Sub CommandButton1_Click()
UserForm1.Show
End Sub

To just load it use

Private Sub CommandButton1_Click()
Load UserForm1
End Sub

rstone25 · Mar 26th, 2002, 04:25 AM

That has worked great.

I tried the load one earlier but it didn't work but the show one is all I need.

Cheers

Dave Hawley · Mar 26th, 2002, 04:53 AM

Yes, the Load only Loads an Object into memory but does not make is visible. The Show Method does both if the UserForm is not loaded.

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

Mar 26th, 2002, 04:13 AM	#1
rstone25 New Member Join Date: Feb 2002 Posts: 14	Hi, I have 2 worksheets - 1 has refreshing data and the other is a form with insturctions on how to use the form. I have created a command button on my form which I want to start another Form (called Userform1 which was done in VBA) I have ripped most of the Module from another xls file and everything else works except this one button. Does anyone know how to set it to load the main userform?

Mar 26th, 2002, 04:17 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	To load and show it use: Private Sub CommandButton1_Click() UserForm1.Show End Sub To just load it use Private Sub CommandButton1_Click() Load UserForm1 End Sub

Mar 26th, 2002, 04:25 AM	#3
rstone25 New Member Join Date: Feb 2002 Posts: 14	That has worked great. I tried the load one earlier but it didn't work but the show one is all I need. Cheers

Mar 26th, 2002, 04:53 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Yes, the Load only Loads an Object into memory but does not make is visible. The Show Method does both if the UserForm is not loaded.