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