Control on worksheet to display 2 col's of data
 

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

--
Message posted from http://www.ExcelForum.com