| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use VBA to reset data validation (=list) value to first value in that list (list is a named range) | Excel Programming | |||
| Crazy Data Validation ... List Validation Not Working | Excel Programming | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Programming | |||
Hybrid Mode
