+ Reply to Thread
Results 1 to 3 of 3

How to link comb boxes in excel ???

  1. #1
    Registered User
    Join Date
    08-19-2009
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    5

    How to link comb boxes in excel ???

    I'm trying to find a way to build combo box for several tables. Attached is an example of the problem I'm facing. In a nutshell, I have three major categories (W. Loaders, T. Loaders, Excavators) and for each one there are a number of equipments with their data. Anyway, I was able to make a combo box for each category but I'm trying to have in cell one the three categories. Once I select the category in cell one the related data will be available in cell 2, 3, 4 because I have three available data for each category. If you have the chance to see the attached file which is just an example, you will have better understanding of what I'm trying to say here.

    Your help is greatly appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: How to link comb boxes in excel ???

    Take a look at the attached and see if this is what you meant.

    See sheet2. You can use Data Validation with the list option and eliminate the need for a combobox.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-19-2009
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: How to link comb boxes in excel ???

    That's exactly what I meant thank you so much.

+ 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