bump...When you set validation in a cell for a list of items & you put more than 8 items in the list, excel makes you scroll to find what you are looking for. Is there a way to increase the limit to 10?[hr]*[/hr]
Increase Data Validation List Item Display
-
-
Re: Cell Validation Pop-up Window
The default length of a list using cell validation cannot be changed.
-
Re: Increase Data Validation List Item Display
you know you probably could change it in xml... wouldn't recommend it though...
why not try another approach and use a comboBox instead?
-
-
Re: Increase Data Validation List Item Display
i don't understand why it wouldn't help? do a little cosmetric 'fancy' on the worksheet and you can link the cell? Does exactly the same as a data Validation List...
-
Re: Increase Data Validation List Item Display
It takes 12 seconds to create a data validation drop down box & I don't have to link it to a cell / range. It fits neatly in a cell too. A combo box on the other hand is more time consuming to setup. I am trying to save time. I just know I would not be satisfied with the combobox solution.
Do you know how to change it in xml? That's what I really need!
-
Re: Increase Data Validation List Item Display
Looks like you can't do it in that bit too...
QuoteDisplay More
<DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
<Range>R3C3</Range>
<Type>List</Type>
<CellRangeList/>
<Value>"1,2,3,4,5,6,7,8,9"</Value>
</DataValidation>
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!