Creating a bigger list in Data Validation

  • Thread starter Thread starter shezageek
  • Start date Start date
S

shezageek

Hi all,

Is Data Validation limited in terms of the items you can create for the drop
down list. I am creating a shopping list and would like to enter in all my
grocerie items, but there are too many. Any work around solutions?
 
How many are your grocery items? There is a scroll down arrow that you can
use, if you mean the number visible every time you click the dropdown
it is 8, however you can put approx 32000 items in a list that can be
selected and you have to do some major shopping to reach that
A combobox from the control toolbox toolbar can have many more items visible
at one time

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Norman, geek,

Just thought I'd mention. In Excel 2002, the Data Validation list doesn't
seem to be limited to 8 items. If the list is larger than 8 items, it uses
a scroll bar. I just made a validation list of 40 items.
 
Earl Kiosterud said:
Norman, geek,

Just thought I'd mention. In Excel 2002, the Data Validation list doesn't
seem to be limited to 8 items. If the list is larger than 8 items, it
uses a scroll bar. I just made a validation list of 40 items.
Click to expand...


Hi Earl,

Thank you, you are quite correct..

I intended to refer to the display length rather than a maximum usage limit
but failed to add a clarifying qualification.
 
Hi Shezageek,

As Earl's adjacent post indicates, the 8 items does not represent a limit
to the number of items which can be used in a a data validation list .That,
as Peo points out, is 32k.

A data validation dropdown displays an extended validation list, 8 lines
at a time, amd provides a scroll bar to scroll through the extended list.

In the link which I gave you, Debra Dalgleish demonstrates a workaround to
display more than 8 items at a time.

I hope that my initial reponse did not mislead you.
 
No problem Norman...I actually figured that out once I got in there and
realized this. No harm done. Thanks and best regards.
 
Back
Top