Hi!

Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.

Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:

=INDEX(J1:J12,D6)

Biff

"Doyle Brunson"
wrote in message
news:Doyle.Brunson.1thb2c_1123560324.0881@excelfor um-nospam.com...

How do I get a combo box to return values not numbers. My combo box
displays January - February, but my linked cell only displays 1-12. How
do i get what is actually in the combo box to appear in the linked
cell.

I have searched for hours for a solution to this - any help would be
great!


--
Doyle Brunson
------------------------------------------------------------------------
Doyle Brunson's Profile:
http://www.excelforum.com/member.php...o&userid=19235
View this thread: http://www.excelforum.com/showthread...hreadid=394114