View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aeronav Aeronav is offline
external usenet poster
 
Posts: 10
Default Data Validation - List

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