+ Reply to Thread
Results 1 to 6 of 6

Create a "Pop-Up" list from which I can select from a list of macro's to run?

  1. #1
    Registered User
    Join Date
    08-06-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    14

    Create a "Pop-Up" list from which I can select from a list of macro's to run?

    Hi Everyone, I have this idea of creating a "Pop-Up" box (Not wanting a Drop-Down list) that I can then select from a choice of existing macros to run. The macros would be simple copy & paste macros.
    So basically I think I would have a button in the top left of screen that opens this "Pop-Up" box, inside that I would select a specific macro to run, which would copy a range from another worksheet and paste it into the selected cell on the current worksheet.
    Is this possible????

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Create a "Pop-Up" list from which I can select from a list of macro's to run?

    Try Alt+F8.

  3. #3
    Registered User
    Join Date
    08-06-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    14

    Re: Create a "Pop-Up" list from which I can select from a list of macro's to run?

    I see what you're saying quekbc but I have so many macros in there that aren't related to this sheet. I'm trying to make it user friendly for extremely limited Excel users, so I am hoping for a more refined list of options.
    Thanks anyway. It was quite a funny answer once I read my question again........ almost seemed too obvious.

  4. #4
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Create a "Pop-Up" list from which I can select from a list of macro's to run?

    Now, this depends on how comfortable you are with VBA.

    What I like to do is, for macros that should not be run by other users, I "hide" them by using either the Private statement (1), or introducing a dummy variable in the parameters (2). This effectively "hides" them from the Alt F8 window.

    (1) Private Sub Macro1()
    -Side effect: This prevents the macro to be called by other macros from a different module
    (2) Sub Macro1(Optional DummyVariable)
    -Side effect: Makes the code longer, may consume more memory (may slow down calcs)

    Alternatively, which I think is what you are thinking of, is to use UserForms, in particular, a UserForm with a ComboBox where you can manually add the names of the macro, and then a button that runs the selected macro.

    E.g. (untested)
    code will be, on UserForm1_Activate, do ComboBox1.AddItem "Macro1Name"
    then on Button1_Click do Application.Run ComboBox1.Text

  5. #5
    Registered User
    Join Date
    08-06-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    14

    Re: Create a "Pop-Up" list from which I can select from a list of macro's to run?

    You've actually answered a question that I hadn't yet even got the chance to ask about....... why some of my macros don't show up.
    This is a very slow process for me as I'm still learning and only able to work on my spreadsheet in short bursts between jobs at work.
    Thanks very much, I'll have to have a play around with that when I get a chance.

  6. #6
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Create a "Pop-Up" list from which I can select from a list of macro's to run?

    No worries, you know where to find us whenever you find yourself hitting a roadblock.

+ 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. Replies: 0
    Last Post: 02-28-2015, 08:19 PM
  2. Replies: 1
    Last Post: 02-20-2015, 01:13 PM
  3. [SOLVED] Formula to pull out data from a list to create "Class Lists"
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2014, 10:09 AM
  4. How to get data "out of" Multi-select userform list box
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2011, 03:53 PM
  5. Replies: 8
    Last Post: 03-07-2011, 01:43 PM
  6. Replies: 8
    Last Post: 01-04-2006, 12:10 PM
  7. [SOLVED] The pivot tables 101 article says to use the "Create List" comman.
    By cgnoland03 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-14-2005, 08:06 PM

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