How to obtain the selected value from a combo box in Excel?
I have a combo box on an excel worksheet, how to write a makro (event handler) to change a cell value as a user choose a number from the combo?

Sub combo_change()
Cells(1, 10) = combo_value??
End Sub

plz help