How to... embed a user form?

Bubba · May 2nd, 2002, 08:21 AM

Hi,

Can anyone tell me how I embed the 'UserForm1' that I've created into my spreadsheet (sheet1)? Currently to use it i have to go into Visual Basic and 'Run Userform'...

Cheers

By the way, I'm still quite new to this VB malarkey

Audiojoe · May 2nd, 2002, 08:23 AM

You could put:

Userform1.show

Into your Worksheet Activate event, or have a button on the sheet with the same code on it

kkknie · May 2nd, 2002, 08:28 AM

Not sure exactly what you mean by embed, but I'll give it a shot.

If what you want is the form to open when the workbook is opened, it's pretty easy.

In the VB editor, double-click This Workbook from the project pane. Type the following:

Private Sub Workbook_Open

UserForm1.Show

End Sub

This will open the userform whenever the worksheet is opened. Check the Excel help files for Event Procedures (since that is what you are using) for more details.

If this is not what you meant, please clarify and I'll try again...

K

Bubba · May 2nd, 2002, 08:30 AM

Cheers mate - it works a treat!

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

May 2nd, 2002, 08:21 AM	#1
Bubba Board Regular Join Date: May 2002 Location: Manchester, England Posts: 73	Hi, Can anyone tell me how I embed the 'UserForm1' that I've created into my spreadsheet (sheet1)? Currently to use it i have to go into Visual Basic and 'Run Userform'... Cheers By the way, I'm still quite new to this VB malarkey

May 2nd, 2002, 08:23 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	You could put: Userform1.show Into your Worksheet Activate event, or have a button on the sheet with the same code on it

May 2nd, 2002, 08:28 AM	#3
kkknie Board Regular Join Date: Apr 2002 Location: Greenwood, SC Posts: 677	Not sure exactly what you mean by embed, but I'll give it a shot. If what you want is the form to open when the workbook is opened, it's pretty easy. In the VB editor, double-click This Workbook from the project pane. Type the following: Private Sub Workbook_Open UserForm1.Show End Sub This will open the userform whenever the worksheet is opened. Check the Excel help files for Event Procedures (since that is what you are using) for more details. If this is not what you meant, please clarify and I'll try again... K

May 2nd, 2002, 08:30 AM	#4
Bubba Board Regular Join Date: May 2002 Location: Manchester, England Posts: 73	Cheers mate - it works a treat!