If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo box in Excel that displays 2 columns
with out VBA can I create a combo box in Excel that displays 2 columns
|
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
You cancelled the previous action error on certain combo box selec | Eamonn | Using Forms | 8 | March 11th, 2006 04:51 PM |
EXCEL should let me establish unlimited numbers of columns. | DAISY | General Discussion | 8 | February 15th, 2006 04:35 PM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
how to increase maximum number of columns in excel 2003 | [email protected] | General Discussion | 1 | January 16th, 2005 08:13 PM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |