Assuming you want a combo box in sheet 1:

Make a list in sheet, lets say A1:A5. Name this list "mylist'

Draw your combo box in sheet one.
Right click on it and choose format control. the input range would be =mylist
the cell link will be anywhere you want (such as C10)

Depending on what you choose from the drop down, C10 will change accordingly.

HTH

For more help, check out contextures.com

"abfabrob" wrote:

I want to use a combo box as a drop down list. I know where to find the combo
box (in the control toolbox), but I have no idea how to populate it or
activate it...

Any help will be appriciated for this real novice

Rob.