| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Control on worksheet to display 2 col's of data
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. --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data in single column split to multiple col's based on header | Excel Worksheet Functions | |||
| Find every 2 col's: SUMPRODUCT, AVERAGE.. | Excel Discussion (Misc queries) | |||
| Find every 2 col's: SUMPRODUCT, AVERAGE.. | Excel Discussion (Misc queries) | |||
| How do I display every 5th row of data from a worksheet in a new . | Excel Worksheet Functions | |||
| Excel control cell display of data with passwords | Excel Worksheet Functions | |||
![goss[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
