Data Validation Drop-down List Limt?
 

Hey All,
I'm trying to populate a data validation with a set of items. Using VBA, I
process a loop that pulls all the items I want in the data validation into a
string, separated by columns. Then I use the with... .validation to add the
validation to the cell. Is there a limit to the number of items that can be
populated in this manner? I've been testing on a list that has ~20 items,
and have found that the list only populates the first 16 items. I've tried
it on other lists, and one w/ 15 items populates fine. I'm curious if
there's an item limit, or a character limit on the input box that's prevent
the 20 item list from fully populating. I'd appreciate any help/ideas.
Thanks,

--Jim D.

Data Validation Drop-down List Limt?
 

apologies, the string the loop pulls in is separated by comas, not columns.
thus, properly:
"....process a loop that pulls all the items I want in the data validation
into a
string, separated by comas."

"Jim D." wrote:

Hey All,
I'm trying to populate a data validation with a set of items. Using VBA, I
process a loop that pulls all the items I want in the data validation into a
string, separated by columns. Then I use the with... .validation to add the
validation to the cell. Is there a limit to the number of items that can be
populated in this manner? I've been testing on a list that has ~20 items,
and have found that the list only populates the first 16 items. I've tried
it on other lists, and one w/ 15 items populates fine. I'm curious if
there's an item limit, or a character limit on the input box that's prevent
the 20 item list from fully populating. I'd appreciate any help/ideas.
Thanks,

--Jim D.

Data Validation Drop-down List Limt?
 

A delimited list in the data validation dialog box is limited to 255
characters.


Jim D. wrote:
Hey All,
I'm trying to populate a data validation with a set of items. Using VBA, I
process a loop that pulls all the items I want in the data validation into a
string, separated by columns. Then I use the with... .validation to add the
validation to the cell. Is there a limit to the number of items that can be
populated in this manner? I've been testing on a list that has ~20 items,
and have found that the list only populates the first 16 items. I've tried
it on other lists, and one w/ 15 items populates fine. I'm curious if
there's an item limit, or a character limit on the input box that's prevent
the 20 item list from fully populating. I'd appreciate any help/ideas.
Thanks,

--Jim D.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html