Data Validation - List

A

Aeronav

Hi,
I am using Vista and Excel 2007
When the source of Data Validation in cells is a list, Excel displays 8
items.
As far as I know there is no custom setting to display more items.
Is there an API or a VBA Sub to display a longer list, 16 or 20 items for
example ?
Thanks
Pingouin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

get Data Validation to stop, list supplied, duplicate data entries 1
Hide column based on data validation 0
limit on the delimited list for Data Validation. 2
Data validation list limit 4
How to Update Selections for (Numerous) Validation Lists 1
Datavalidation with shrinking non blank values 1
Worksheet protection prevents Data Validation code from running... 1
Data Validation Drop-down List Limt? 2

Top