Hi, all. This is my first time working with VB, but I have a some experience with HTML and CSS and a little knowledge of C++ and Python. I use Microsoft for work and Linux Debian on my home machine, so this is a whole new world for me.



I'm trying to create a macro for work that will allow me to do the following:

• Choose a county from a dropdown list
• Automatically populate a county code
• Populate a dependent dropdown list with the towns and cities in the county

I'm running into a few issues, such as the legacy dropdown form for Word 2016 allowing only 25 choices, and the code I have written for the default dropdown list doesn't work, since it's probably for the legacy form. I live in Mississippi, and we have 82 counties. I also don't know how to make an auto-populating text box based on a dropdown list choice. Is there a way to get around the limit, or is there a different method for creating the dependent drop-down list?

Any advice, guidance, links to learning material, and suggestions are welcome. I will be glad to post the code I have written for reference if needed.

Thanks!

Liz

Liz,


There is no limit to the number of entries that you can have in a ContentControl dropdown list. When you build your entries, you can assign the county name as the text property and the country code as the value property. Content controls have event procedures in the ThisDocument module of the document vb project. You can use the exit event to built your dependent city and town list entries in your dependent dropdown list.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/