What tool do you wish to use when creating or editing the combobox object?
For instance, in Excel VBA editor you may add the routine like:

Private Sub ComboBox1_Change()
    Range("C9").Value = ComboBox1.Value
End Sub

>hi all,
>
>i have created an MS Excel worksheet which has a combobox on top of cell address C9. In the combobox i am displaying some text values for selection. i want store the text selected from the combobox in the cell C9. what command do i need to help me achieve this result ?
>
>for example, if in the combobox the value "apple" is selected, i want the text "apple" to be stored on cell C9
>
>with sincere thanks in advance