Control on worksheet to display 2 col's of data

  • Thread starter Thread starter goss
  • Start date Start date
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
 
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.
 
Back
Top