Last month’s article, “ Pro tip: Add a UserForm to aid data entry in Excel,” shares the basics of creating an Excel UserForm using VBA to populate list controls. To update the list, you can ...

Populating a userform combo box with a static list takes a little knowledge and some VBA code. Getting the combo box to update when the list updates requires a bit more work.