>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

Sub DropDown5_Change()
    Range("C9").Value = DropDown5.Text
End Sub

Cetin