ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo Box, show multiple columns (https://www.excelbanter.com/excel-discussion-misc-queries/208283-combo-box-show-multiple-columns.html)

Melissa

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?

ShaneDevenshire

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