Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: inserting vba into excel

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Cambridge, UK
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •