Combo box in Excel that displays 2 columns
 

with out VBA can I create a combo box in Excel that displays 2 columns

Combo box in Excel that displays 2 columns
 

I can't see a way to do this, but you could 'cheat' and have an extra
columns that combines the two columns.
e.g. Dog is in A1 and Cat is in B1.
In C1 use the formula =A1&" "&B1 to give Dog Cat as the answer.
Then have the Combo box looking at column C.

ichu05 Wrote:
with out VBA can I create a combo box in Excel that displays 2 columns


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=524943