Microsoft Office Forums - View Single Post - [Solved] Work around for more than 25 items in drop-down menu

macropod · 06-13-2021, 04:42 PM

So why are you using formfields instead of content controls?

That aside, you could have a county selector with 25 items, the last of which has 'page 2' and, when that item is selected, a macro clears the 'page 1' list and displays the 'page 2' list. The 'page 2' list would have 'page 1' as its first item (so you can go back) and a 'page 3' entry as the last item. Etc. The same approach could be taken at the state level, since you have more than 25 states to deal with. See attached.