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

Data Validation - List
 

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

Data Validation - List
 

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" a écrit dans le message de
...
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

Data Validation - List
 

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" a écrit dans le message de
...
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

Data Validation - List
 

Many Thanks, Sheelo.
I did know this possibility
Pingouin

"Sheeloo" a écrit dans le message de
...
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" a écrit dans le message de
...
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