Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Location
    Green Bay, Wisconsin, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Drop-down Data Validation List (Excel 2000/SR1)

    I use a drop-down list for data validation in a cell. The drop-down list shows 8 entries with a scroll bar for additional entries. Is it possible to increase the size of the list so I don't need to use the scroll bar (say to 15 entries)?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drop-down Data Validation List (Excel 2000/SR1)

    Sorry, there is no way that I know of.
    Legare Coleman

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drop-down Data Validation List (Excel 2000/SR1)

    By Data Validation, do you mean THE "data validation" menu or do you mean generically? <img src=/S/duck.gif border=0 alt=duck width=23 height=23> I ask because LegareColeman is right that the size of the drop down box isn't configurable if you use the menu "Data Validation". On the other hand, you can do your own (sort of) by drawing a combobox on that same cell (with Forms tool bar) and then supplying the same data for display. The # of drop downs is selected for the Combobox (not for the Listbox though) This has the same apperance (almost the same) as the "Data Validation" feature. You'll have to then change how you detect the selected item though.

    In the menu "Data Validation" the selected item is written directly to that cell. If you instead create your own combobox it'll be detected differently depending whether the combobox was chosen from the Form toolbox or the Controls toolbox. If you pick the combobox from the Forms tool bar, you'd right-click and select "format control" to populate it as well as select the "output/result" cell. This is the cell that will contain the index to the item selected. Your code (or formula) wll then have to read that output cell to determine which item was picked.

    Example: Combobox (from Forms tool bar), contains: Moose, Cow, Horse, Goat, Squirrel. You chose cell D12 as the output/result cell.

    If user selects Cow, D12=2 since it's the 2nd item in the list. (If you used THE data validation feature, D12 = "Cow")
    The items listed ("Moose, Cow....") can be written anywhere on the sheet and then hidden (coloredwhite) so they're not easy to find and destroy)

    Don't know if this is helpful or not, just wanted to get you thinking about other choices. <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

    Deb

Posting Permissions

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