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?

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?

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?

Combo box in excel
 

Its taken me hours of searching to find this info. Thanks. Now I need t
know how that text can be linked to a numerical value in a cell

--
Message posted from http://www.ExcelForum.com