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

Try a combo-box. It allows more than 8 entries.

"Aeronav" wrote:

> 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
>
>

Many Thanks, Sheelo.
I did know this possibility
Pingouin

"Sheeloo" <(E-Mail Removed)> a écrit dans le message de
news:5238F006-773C-457E-9191-(E-Mail Removed)...
> The same way you are putting a List validation in all of them :-)
>
> You need only one comboBox as suggested by Debra at
> http://www.contextures.com/xlDataVal10.html
>
> "Aeronav" wrote:
>
>> Sure, but I cannot (and do not want) put a combo on each of the 7547
>> cells
>> of my column, with a linked cell for each...
>> Pingouin
>>
>> "Sheeloo" <(E-Mail Removed)> a écrit dans le message de
>> news:8C672B1B-6F5F-4DDA-ADEB-(E-Mail Removed)...
>> > Try a combo-box. It allows more than 8 entries.
>> >
>> > "Aeronav" wrote:
>> >
>> >> 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
>> >>
>> >>
>>