>hello cetin,
>
>sincere thanks for your reply posted in response to my query.
>
>however, i still get the error message "run-time error 424 : object required" when i tried the folowing command -
>
>Sub DropDown5_Change()
> Range("C9").Select
> ActiveCell.FormulaR1C1 = DropDown5.Text
>End Sub
>
>please help me get with the solution.
>
>with kind regards and sincere thanks

If you've used a combo from control toolbox it works. Maybe you used one from forms toolbar.
Cetin