hello,

i have a combobox named DropDown_5 placed on an excel worksheet. from this combobox i am displaying some values which i want a user to select from. On selecting a value from the combobox, i want to put the selected value in cell number C9 of my excel worksheet. I am unable to complete the command sequence below that would help me achieve my objective. Can someone please help me out.

With sincere thanks.

Sub DropDown5_Change()
Range("C9").Select
ActiveCell.FormulaR1C1 = .................

End Sub