+ Reply to Thread
Results 1 to 4 of 4

Run macros from more than one dropdown list in a worksheet

  1. #1
    Registered User
    Join Date
    09-22-2016
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    2

    Run macros from more than one dropdown list in a worksheet

    Hi,

    I have a worksheet with runs a choice of macros from a dropdown list using the code below.


    Please Login or Register  to view this content.
    I would like to have another dropdown with a different set of macros which can also be run in the same manner. To do this I have used the code below.

    Please Login or Register  to view this content.
    However I do not know how to make both of these function within the same worksheet. They work individually but when I attempt to have both of them it says "Compile error: Ambiguous name detected: Worksheet_Change"

    Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Run macros from more than one dropdown list in a worksheet

    You can only have one Worksheet_Change in a worksheet. Try this, although I have not tested it since I don't have all those Subs that you have.

    Please Login or Register  to view this content.
    Last edited by 6StringJazzer; 09-25-2016 at 10:39 PM. Reason: changed Else If to ElseIf
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-22-2016
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    2

    Re: Run macros from more than one dropdown list in a worksheet

    Thank Jeff,

    That works perfectly. Was just a case of me using VBA code without actually knowing how it all works.

    Appreciate the help.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Run macros from more than one dropdown list in a worksheet

    You're welcome! Thanks for the rep, and thanks for marking your thread Solved!

+ 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] Running macros by making a selection in a dropdown list
    By blueshift1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2012, 02:22 PM
  2. Dropdown List from Another Worksheet
    By mycon73 in forum Excel General
    Replies: 3
    Last Post: 02-03-2011, 06:46 PM
  3. Mutiple Macros from Dropdown list?
    By smogsy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2010, 06:34 AM
  4. Using a dropdown list to autofill a worksheet
    By throughhiseyes7 in forum Excel General
    Replies: 4
    Last Post: 07-08-2010, 01:57 PM
  5. create a dropdown list on one worksheet/tab, from another worksheet/tab
    By harchunk in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-16-2007, 03:46 AM
  6. How to select different Macros from a dropdown list?
    By globulous in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2007, 12:16 AM
  7. Worksheet List, Dropdown List Excel 2000!
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2006, 12:10 AM
  8. how can I remove a dropdown list from my worksheet
    By Boomer in forum Excel General
    Replies: 4
    Last Post: 04-04-2006, 11:10 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