+ Reply to Thread
Results 1 to 2 of 2

Assign macro to each item of a drop-down list or combo box - how?

  1. #1
    Registered User
    Join Date
    07-04-2005
    Posts
    3

    Assign macro to each item of a drop-down list or combo box - how?

    I've posted this a while ago, but I keep getting the same recurring problem, namely that I can't get it to work...and I'm not 100% sure that people really knew what I was on about before anyway

    I desperatly need to have a macro that will launch a specific macro when an item is selected in the combo box or drop-down list. i.e. I have a list with item "X" and item "Y" and macros "X" and "Y" which need to run when the corresponding items are clicked on. I need to create macro "Z" which I can assign to the combo box/drop-down list which will allow me to do this.

    Please bear in mind I have near to zero knowledge of VBA.

    Thank you in advance

  2. #2
    Bob Phillips
    Guest

    Re: Assign macro to each item of a drop-down list or combo box - how?

    To avoid repetition, what replies did you get before, and what was wrong
    with them?

    --
    HTH

    Bob Phillips

    "jbp20717" <jbp20717.1stp2q_1122458767.8044@excelforum-nospam.com> wrote in
    message news:jbp20717.1stp2q_1122458767.8044@excelforum-nospam.com...
    >
    > I've posted this a while ago, but I keep getting the same recurring
    > problem, namely that I can't get it to work...and I'm not 100% sure
    > that people really knew what I was on about before anyway
    >
    > I desperatly need to have a macro that will launch a specific macro
    > when an item is selected in the combo box or drop-down list. i.e. I
    > have a list with item "X" and item "Y" and macros "X" and "Y" which
    > need to run when the corresponding items are clicked on. I need to
    > create macro "Z" which I can assign to the combo box/drop-down list
    > which will allow me to do this.
    >
    > Please bear in mind I have near to zero knowledge of VBA.
    >
    > Thank you in advance
    >
    >
    > --
    > jbp20717
    > ------------------------------------------------------------------------
    > jbp20717's Profile:

    http://www.excelforum.com/member.php...o&userid=24886
    > View this thread: http://www.excelforum.com/showthread...hreadid=390502
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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