apply vbs form to click button

dantb · Mar 22nd, 2002, 06:42 AM

New at vbs, can anyone tell me how, after writing a form in visual, to attach it to a click button in excel where it will pull the form up. Thx Dan

Mark O'Brien · Mar 22nd, 2002, 07:34 AM

Right click on the name tab of the worksheet that contains the button, choose "View Code". In the VB editor that comes up you will see two drop-down menus, one will say "(General)" and the other will say ")Declarations"). Click on the arrow for the "(General)" box, and you should see the name of your button in that list. Select that button. You will now see some code in the window that says something like:



Private Sub CommandButton1_Click()



End Sub

Put your code to show the userform in here. e.g. if your userform is called "UserForm1" then you put this line of code in to show the userform:



UserForm1.Show

Go back to your work book and hopefully if you click your button the userform will show. If nothing happens that check the toolbar called "Control Toolbox" and make sure that the "Design Mode" button hasn't been pressed.

HTH

dantb · Mar 22nd, 2002, 07:56 AM

Thanks Mark works great, so simple but I could not figure it out. Thanks again.

Mar 22nd, 2002, 07:34 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Right click on the name tab of the worksheet that contains the button, choose "View Code". In the VB editor that comes up you will see two drop-down menus, one will say "(General)" and the other will say ")Declarations"). Click on the arrow for the "(General)" box, and you should see the name of your button in that list. Select that button. You will now see some code in the window that says something like: Private Sub CommandButton1_Click() End Sub Put your code to show the userform in here. e.g. if your userform is called "UserForm1" then you put this line of code in to show the userform: UserForm1.Show Go back to your work book and hopefully if you click your button the userform will show. If nothing happens that check the toolbar called "Control Toolbox" and make sure that the "Design Mode" button hasn't been pressed. HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

Mar 22nd, 2002, 06:42 AM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	New at vbs, can anyone tell me how, after writing a form in visual, to attach it to a click button in excel where it will pull the form up. Thx Dan

Mar 22nd, 2002, 07:56 AM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Thanks Mark works great, so simple but I could not figure it out. Thanks again.