+ Reply to Thread
Results 1 to 3 of 3

Linking Combo Box multiple cells

  1. #1
    Registered User
    Join Date
    10-04-2011
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    5

    Linking Combo Box multiple cells

    I am trying to use a Combo box to control a value in a row. There are about 300 rows and each could have one of 6 different values. I need each combo box to be linked to the cell in its specific row. this code

    Please Login or Register  to view this content.
    Makes this possible for Check boxes. Is there a similar code for combo boxes?

    Thanks in advance.

  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,691

    Re: Linking Combo Box multiple cells

    The exact same code will also work for comboboxes.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

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

    Re: Linking Combo Box multiple cells

    By the way, do you really need to use comboboxes for this? Could you use data validation with a list and dropdown boxes? It would be much easier to set up and maintain.

+ 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