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