To fill a combobox:

VBA for smarties How to fill a Combobox / Listbox