Ask a new question

Dependant drop down lists

I am creating dependent drop down lists using the method shown at this link:

http://gregmaxey.mvps.org/word_tip_pages/linked_content_control_dropdown_list.html

Following this example, I have currently entered 28 types of fruit in the value field for when "Fruit" is chosen as the "Food Group".  I seem to be limited to 256 characters.  My current needs are for 30 - 35 items, totaling a minimum of about 350 - 400 characters, including spaces, pipes, and all.  It would be ideal if I could have 40 - 50 items totaling 1,000 - 1,500 characters.

Question: Can I get around this limitation?  If so, please provide a reference or example I can follow for whichever method you suggest.  Thank you.

Answer
Answer

For an alternative approach with no meaningful character limits*, see: http://www.msofficeforums.com/word-vba/24661-help-cascading-dropdown-list.html

* A variable-length string can contain up to approximately 2 billion (2^31) characters.
* A fixed-length string can contain 1 to approximately 64K (2^16) characters.

Cheers
Paul Edstein
(Fmr MS MVP - Word)

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 636 Applies to: