VBA Help!!!

rstone25

New Member
Joined
Feb 17, 2002
Messages
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?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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
 
Upvote 0
That has worked great.

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

Cheers
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top