Combo Box, show multiple columns

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I populate a cell with data from a cell in another workshe. 1
Combo box 2
How to join row data into one row 1
Adding Problem 6
sheet with multiple tabs 3
Auto sum 2 adjacent row data into 3rd row? 1
subtotal data from 2 columns into 3rd column 1
Help with Conditional Formatting 5

Back
Top