combo boxes

Mar 13th, 2002, 03:51 PM

I need to know something, I've created the combo box and linked it to the range of data.
i have used "help" and discovered the index formula, but, i need to know how to make the selection that is clicked appear in another cell.

Aladin Akyurek · Mar 13th, 2002, 04:06 PM

Quote:

On 2002-03-13 14:51, Anonymous wrote:
I need to know something, I've created the combo box and linked it to the range of data.
i have used "help" and discovered the index formula, but, i need to know how to make the selection that is clicked appear in another cell.

If you used Forms from Toolbars to create the ComboBox, you can use:

=INDEX(SourceList,CellLink)

where SourceList is what you used as Input Range and CellLink is the cell you anchored the ComboBox.

[ This Message was edited by: Aladin Akyurek on 2002-03-13 15:07 ]

Daniel Cremin · Mar 13th, 2002, 04:10 PM

right no probs- you create the combo box based on the range of information you want to be picking from and give it a cell link - then in the cell where you want the information you pick to appear you enter an Index Function specifiying the range of cells that act as the basis for the combo box rang of cells as your array, and you set the cell you made as the cell link be the row source or cell -in the formula by selecting it - then if you pick the first name off the list using the drop-down box the no 1 appears in the cell link and then the index formlua looks down the list of information and finds the first cell entry.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 03:51 PM	#1
Guest Posts: n/a	I need to know something, I've created the combo box and linked it to the range of data. i have used "help" and discovered the index formula, but, i need to know how to make the selection that is clicked appear in another cell.

Mar 13th, 2002, 04:10 PM	#3
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	right no probs- you create the combo box based on the range of information you want to be picking from and give it a cell link - then in the cell where you want the information you pick to appear you enter an Index Function specifiying the range of cells that act as the basis for the combo box rang of cells as your array, and you set the cell you made as the cell link be the row source or cell -in the formula by selecting it - then if you pick the first name off the list using the drop-down box the no 1 appears in the cell link and then the index formlua looks down the list of information and finds the first cell entry.