Combo box in Excel that displays 2 columns

C

Clivey_UK

I can't see a way to do this, but you could 'cheat' and have an extr
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Combo box 0
Combo or list box 0
Need help merging Excel into Publisher Booklet w 2 columns 0
Word OLE to check spelling in text box 1
Autonumber field in Excel that behaves the same as Access 0
Need Help with a VBA subroutine 0
Possible to Combine reports to's to a single box? 0

Top