Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box in excel
Hello,
I have inserted a combo box into my spreadsheet using the forms toolbar, I have assigned it to a range of cells for data selection and linked it to a cell for data output. What I am wondering is how to get the output from the combo box to be the actual textual data that is in the list rather than the line number of the cell in the range? Make sense? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box in excel
Dustin,
You can use the Combobox from the Controls toolbar. Right click it and under properties use the ListFillRange and LinkedCell properties. This returns the value, instead of the row number. Be sure to exit Design Mode after you set the properties. hth, Doug "Dustin" wrote in message ... Hello, I have inserted a combo box into my spreadsheet using the forms toolbar, I have assigned it to a range of cells for data selection and linked it to a cell for data output. What I am wondering is how to get the output from the combo box to be the actual textual data that is in the list rather than the line number of the cell in the range? Make sense? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box in excel
Thanks, Doug!
"Doug Glancy" wrote in message ... Dustin, You can use the Combobox from the Controls toolbar. Right click it and under properties use the ListFillRange and LinkedCell properties. This returns the value, instead of the row number. Be sure to exit Design Mode after you set the properties. hth, Doug "Dustin" wrote in message ... Hello, I have inserted a combo box into my spreadsheet using the forms toolbar, I have assigned it to a range of cells for data selection and linked it to a cell for data output. What I am wondering is how to get the output from the combo box to be the actual textual data that is in the list rather than the line number of the cell in the range? Make sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
In Excel I need to set up a combo box based on another combo box. | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |