excel+course - Input boxes vs List

Hi Kenneth,

Thanks for the question.

To create a drop down list, you must first draw a COMBO BOX from the TOOLBOX toolbar. Switch on properties to name it, e.g. cboList1

Once it's drawn, double click inside the COMBO BOX picture.
Put in the code starting with combo box name, for example:

cbolist1.additem "SalesPerson1"

The .additem code will add labels into the box.

Hope this helps.

Regards,

Katie