Combo box in excel

[Dustin]

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?

 

[Doug Glancy]

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

 

[DustinS]

Thanks, Doug!

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

 

[ajw150]

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