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