inserting vba into excel

[dantb]

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]

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.

 

[Legacy 98055]

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]

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