Interdependent drop-down boxes in Word forms (part 1)

[RBLampert]

I'm creating a form for a national organization that is divided into regions,
states, and chapters. There are a lot of chapters and state organizations,
far over the 25 entry limit for drop-down boxes, and I don't want to create a
drop-down box with over 200 entries if I turn off the limit. Is there a way
to link a set of drop-down boxes so that if the user selects a particular
region, in the State box, they'll only see the states that are part of that
region, and then, a second time, see only the chapters assigned to a
particular state when the state is selected?

 

[Doug Robbins - Word MVP]

See the final section of

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

You are going to have to get started with VBA real quick
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Doug Robbins - Word MVP]

The various choices could all be hard coded into the form. Having them in a
separate document is an easy way to set them up and maintain them.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP