+ Reply to Thread
Results 1 to 4 of 4

How can I connect a button on my spreadsheet to launch my UserForm?

  1. #1
    Registered User
    Join Date
    01-17-2012
    Location
    Pacific Northwest
    MS-Off Ver
    Excel 2019
    Posts
    87

    How can I connect a button on my spreadsheet to launch my UserForm?

    I've added a button to my spreadsheet and I've added both a UserForm named frmInput and a modual but I can't find a way to get the button to launch my userform. After researching, I understand I need to add frmInput.show but I haven't found anywhere (in either the frmInput or the modual) to add that line, that launches the Userform.

    I intended to include the version of Excel that I'm using but apparently the traditional "About" button is no longer traditional so I have no idea what version I'm using.
    Any clues you have to offer would be appreciated. Thanks

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: How can I connect a button on my spreadsheet to launch my UserForm?

    Create a Macro in a Macro Module@

    Please Login or Register  to view this content.
    Create your button. Right Click on the button and assign the Macro Test to the button.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    01-17-2012
    Location
    Pacific Northwest
    MS-Off Ver
    Excel 2019
    Posts
    87

    Re: How can I connect a button on my spreadsheet to launch my UserForm?

    THANK you so VERY MUCH! After stumbling around trying to figure out exactly how to create a Macro in a Macro Module, I eventually came to the conclusion that I should have placed my button AFTER I created my userform. Once I added a new button to my spreadsheet, the Macro Option magically appeared and it even works!

    NOW... my problem is HOW to get rid of the first button? Selecting it creates a dashed line around the inside of the button but it doesn't seem to do anything else. I see no "REMOVE" control option and selecting the cells around the button and deleting had no effect.
    Thanks again for your help! Two buttons (one which works! is STILL an improvement to one dead button)

  4. #4
    Registered User
    Join Date
    01-17-2012
    Location
    Pacific Northwest
    MS-Off Ver
    Excel 2019
    Posts
    87

    Re: How can I connect a button on my spreadsheet to launch my UserForm?

    I found the answer with a little more research! THANKS again for your kind assistance!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Userform Launch - show userform when any cell in range on any worksheet is double clicked
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2016, 03:38 AM
  2. Unable to launch userform from button on worksheet
    By savferns01 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2016, 06:15 AM
  3. Attempting to use OK button to save data from userform to spreadsheet.
    By AcoloyteAndrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2014, 06:08 PM
  4. Launch application by command button on excel vba userform
    By Benjamin2008 in forum Excel General
    Replies: 1
    Last Post: 12-20-2013, 05:15 PM
  5. [SOLVED] Launch a userform from toolbar instead of command button
    By Clare Smyth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2013, 12:17 PM
  6. How to launch macro or other userform after command button.
    By Karkas in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-06-2009, 08:49 PM
  7. Macro launch - Button vs Manual launch , has different results.
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2005, 08:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1