Andrew has attended:
Excel VBA Intro Intermediate course
Combobox
What are the different ways to load a combobox using VBA?
RE: combobox
You need to set the RowSource property of the ComboBox control. An easy way is to set this to the name of a Range in the workbook. Typically this will have a single column, but could have more.
/Roy