Joel,Originally Posted by beaso
If you just want a drop down list in the cell, how about using data validation. If you set it to list, you can use a list of values(from the current sheet only) to populate the list. Since it is the cell you don't need to worry about set the cell value.
Alternatly, on the combo box control, you can just go into the properties and set Linked Cells to the cell you want to store the value in.