Re: Data Validation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Norman Harker (njharker_at_optusnet.com.au)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 10:24:39 +1000

Hi Kristy!

You can't show more than 8 rows in a data validation drop down.

As for the number of items in the list, I can't seem to get more than
32767, but that should be enough and it makes loading the list very
slow. 

-- 
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Kristy Simshauser" <ksimshau@bigpond.net.au> wrote in message
news:lEJ9c.128936$Wa.61908@news-server.bigpond.net.au...
What is the maximum number of entries that will be display in a data
validation list?
Thanks,
K

Relevant Pages

  • Re: can you make a drop down list in a drop down list?
    ... Data Validation -- Dependent Dropdowns from a Sorted List ... Data Validation -- Create Dependent Lists ... "_range") and it will pull the appropriate sublist each time the JOBS cell is ...
    (microsoft.public.excel.misc)
  • Re: How do I validate data from another validation cell?
    ... I haven't looked at Julie's file, but in Excel 97, selecting an item from a Data Validation dropdown list doesn't trigger a Change event, unless the list items have been typed in the Data Validation dialog box. ... the file is at the end of the Excel bit called SAMPLE WORKBOOK Dependent data validation lists using VBA. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: comboboxes
    ... This technique shows how to create dynamic dropdown lists in VBA. ... Combobox Version ... Data Validation Version ... Dim cell As Range ...
    (microsoft.public.excel.programming)
  • Re: comboboxes
    ... The sample workbook contains two formats for accomplishing what I am looking ... The second, which is what I would prefer to use, uses the data validation ... workbook when trying to change the value in the first combobox: ... > This technique shows how to create dynamic dropdown lists in VBA. ...
    (microsoft.public.excel.programming)
  • Re: How can I use a named range for "pick from drop-down list"?
    ... the next release of Excel will include ... or optional feature to the pick from drop-down command. ... > Data Validation dropdown lists don't support autocomplete. ... > which you can select one of the values from the data validation list. ...
    (microsoft.public.excel.misc)