inserting vba into excel

dantb · Mar 21st, 2002, 09:50 AM

New at visual basic. After creating a vbs form, how do you insert it or creat a button to insert it into a excel sheet?

LLoyd · Mar 21st, 2002, 10:38 AM

In Excel, left click in the toolbar section at the top of the window and select 'Control Toolbox'. You can click on the icons and draw buttons or whatever on your sheet.

Tom Schreiner · Mar 21st, 2002, 10:42 AM

I'm sure there are other ways to do this, but here is the way I do it

Create a button, hotkey, picture, or whatever else you can assign a macro to and then show the form from the macro.

If you are not sure how to do this:

Click on your form and check it's properties for the name given if you did not name it yourself. If it is the only form in your project, it will be called form1...

Anyway, in the macro type:
form1.show

Replace form1 with the name you gave your form in necc.

CapsHockey · Mar 21st, 2002, 10:42 AM

If you have a pre existing form created in vb, you can import it from the VB Editor using File Import.

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

Mar 21st, 2002, 09:50 AM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	New at visual basic. After creating a vbs form, how do you insert it or creat a button to insert it into a excel sheet?

Mar 21st, 2002, 10:38 AM	#2
LLoyd New Member Join Date: Mar 2002 Location: Cambridge, UK Posts: 4	In Excel, left click in the toolbar section at the top of the window and select 'Control Toolbox'. You can click on the icons and draw buttons or whatever on your sheet.

Mar 21st, 2002, 10:42 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	I'm sure there are other ways to do this, but here is the way I do it Create a button, hotkey, picture, or whatever else you can assign a macro to and then show the form from the macro. If you are not sure how to do this: Click on your form and check it's properties for the name given if you did not name it yourself. If it is the only form in your project, it will be called form1... Anyway, in the macro type: form1.show Replace form1 with the name you gave your form in necc.

Mar 21st, 2002, 10:42 AM	#4
CapsHockey New Member Join Date: Feb 2002 Posts: 5	If you have a pre existing form created in vb, you can import it from the VB Editor using File Import.