![]() |
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? |
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? |
All times are GMT +1. The time now is 01:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com