Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box, show multiple columns
I have a combo box that references a list of 4 columns. I have the column
width property in the combo box set up as 50pt, 0pt, 0pt, 100pt so the list shows the first and second columns of my list. When I choose an option in the list I see the data in columns 1 & 4 like I want: Ex: 1234 Joe Smith However after I select the person I only see the 1234 in the combo box itself, how can I show both 1234 and Joe Smith after they have been selected? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box, show multiple columns
Hi,
I'm not clear on this one, you have your columns set to 50, 0, 0, 100 and then you say you see columns 1 and 2? I would expect to see 1 and 4. You might try a concatenated single column display. For example the list would display one column =Column1 & " - " & Column4 -- Thanks, Shane Devenshire "Melissa" wrote: I have a combo box that references a list of 4 columns. I have the column width property in the combo box set up as 50pt, 0pt, 0pt, 100pt so the list shows the first and second columns of my list. When I choose an option in the list I see the data in columns 1 & 4 like I want: Ex: 1234 Joe Smith However after I select the person I only see the 1234 in the combo box itself, how can I show both 1234 and Joe Smith after they have been selected? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My titles won't stay when i select columns to merge into a combo b | Excel Discussion (Misc queries) | |||
adding blank cells to multiple columns to show similarities | Excel Discussion (Misc queries) | |||
Combo Box - Show only first two digits? | Excel Discussion (Misc queries) | |||
Combo box in Excel that displays 2 columns | New Users to Excel | |||
How does Excel Sheet with combo box show it when used projector? | Excel Worksheet Functions |