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.

With the combo box still selected, find the Row Source property and enter ClassRange (Figure D). That’s the name of the range (list) you created earlier (see Figure B).