Control on worksheet to display 2 col's of data

G

goss

Greetings and happy new year - ng!

Using xl xp pro
Would like to add list box or other control for user to make selection
Souce list contains unit number in col a / unit name in col b

Would like both displayed in control
I click format control
Click ellipse
Hichlight both col's
Enter
However only col a is visible in the list box

How can I make both col's visible as most users like names not numbers?

tia
goss
 
S

shades

I assume that you made the List Box using the Control Toolbar. If you
right-click on the list box, choose Properties, go to ColumnCount and
change that number to 2.
 

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

Control on worksheet to display 2 col's of data 0
Input Data to Webpage 1
ComboBox Dropdown not under control 1
Combo box 2 columns 2
repost: convert +/- on text value 1
"Which control to use in a UserForm?" 2
Index on another worksheet 5
Code "crashes" after dynamically adding control to worksheet 3

Top