| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Combo box in Excel that displays 2 columns
with out VBA can I create a combo box in Excel that displays 2 columns
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I create more than 266 columns in an excel sheet? | Excel Discussion (Misc queries) | |||
| Every second time i open Excel, it displays the document recovery pane | Excel Discussion (Misc queries) | |||
| Why can't I insert a Combo Box in Excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Linear Mode
