G
Guest
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.
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.