Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Combo Box (Excel 2002)

    In the attached spreadsheet, I am attempting to use a Combo box which was created through the Forms toolbar.

    The Combo box draws the names from sheet, A2:A9. The formula I am using in B2 is =INDEX(Sheet9!A2:A9,I1). The resulting index number is behind the Combo box and the name drawn by the formula is then placed in cell B2.


    I would like to be able to use the formula down column B in order to make another selection. Presently if I copy the formula down to B3 I will get the same information showing in B2.

    I know that I can do this through Data Validation, but Data Validation limits the number of items in the dropdown list.

    Is what I am attempting to do with the Combo Box possible with the INDEX formula or must I use some VBA?

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Combo Box (Excel 2002)

    If you have more items than Data | Validation can handle, it's time to rethink your strategy. It's not reasonable to expect people to wade through thousands of items. Perhaps you could use a two-stage selection.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Combo Box (Excel 2002)

    I appreciate your comment, but I am just trying to learn more about what can and can't be done with a Combo Box. This is just an attempt to see if it is possible. The combo box would be limited to 12 to 15 items, that I want a user to be able to select down column B. I have used 2 stage selection process with data validation and realize that it is possibly a better method. As I said, just trying to learn more about using combo boxes.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Combo Box (Excel 2002)

    In your original post you stated that you didn't want to use Validation because of the limited number of items. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    But anyway, a combo box is bound to only one linked cell, so you must either create as many combo boxes as you have rows to fill, or you must write complicated code to use one combo box for different cells. Not something I'd fancy.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Combo Box (Excel 2002)

    My comment about limited items is that DV only allows a limited selection. Your answer " a combo box is bound to only one linked cell" is a learning moment for me. Thank you very much, as I was not aware of that fact. As stated, attempting to learn more about combo boxes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •