Populating a combo box isn't hard, but getting the combo box to communicate with a constantly changing list is a little more difficult. Learn how to populate your combo box with a dynamic list.

First, we’ll embed a combo box control. Then, we’ll use a VBA event procedure to change the control’s font color, based on the selected value.