View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
goss[_4_] goss[_4_] is offline
external usenet poster
 
Posts: 1
Default 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
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