+ Reply to Thread
Results 1 to 3 of 3

Assigned Macro to Combo Box(Form Control)

  1. #1
    Registered User
    Join Date
    07-30-2009
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Assigned Macro to Combo Box(Form Control)

    I have tried several of what the forums have stated should work. I still need help. I can not get anything to work correctly. I would be more than happy to share the file that I am working on. I have correctly inserted a Combo Box(Form Control). The Combo Box has a range of 6 cells with text. I have also assigned a CellLink to create a value. I can easily assign a macro. What I want to do is for each selection of the drop down menu it will run a different macro. The Combo Box has a Macro assigned. This is the code I have been playing with. Thanks to anyone who wants to help.
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 07-30-2009 at 02:12 PM. Reason: Added Code Tags

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Assigned Macro to Combo Box(Form Control)

    Hello Pantus,

    Welcome to the Forum!

    Since you are still having problems making this work, you should post your workbook for review. It will get you an answer faster. If you are using Excel 2007, you should also post of copy of the workbook in Excel 2003 format.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    11-18-2009
    Location
    PHL
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Assigned Macro to Combo Box(Form Control)

    I have the exact same problem and I used the exact same code... I guess i should preface this reply by stating I am completely new to VBA and macros. I did not have any problems recording the macros or assigining an individual macro to an individual control. However, when i attempt to write the code to assign multiple macros to the listed items within a Combo Box (form control) I receive a Run-Time error 1004. Is the code stated in the original post correct? Thanks in advance. I can upload the worksheet if needed.

    I am using 2007.

    G.

+ 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