View Single Post
 
Old 10-30-2023, 07:33 AM
anxious-oracle's Avatar
anxious-oracle anxious-oracle is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2023
Location: Mississippi
Posts: 1
anxious-oracle is on a distinguished road
Default Auto-population and dependent dropdown list macro

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
Reply With Quote