Combo Box Question

[Ned Ludd]

I hope you can help. I have searched the form without success.

I have a combo box with 3 items in it. All I want to do is copy the selected item from the list and copy it in another cell.

ie.

My combo box has these items

one
two
three.

They are listed from F50:F52

If I select "three" in the combo box (ie F52) I want "three" to show up in cell b14.

I can not figure this out. If there is a formula based solution, I'd really appreciate it as I know didley about VB.

Thank you!

 

[acw]

HI

I'm assuming that you have a combobox on a spreadsheet. If so, have a look at the linkedcell property. Put B14 as the output cell and the selection from the combobox will be placed there.


Tony

 

[mightymishra]

Link cell B14 to the combo box and
formula in C14 -> "=Index(F50:F52,B14)"
this would return the text selected in the combo box

 

[Ned Ludd]

Thank you very much for your help. The Linkedcell feature worked perfectly.

Ned.