| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up multiple fields in a list box?
I want to display multiple values in a list box or combo box from 2 columns?
The first column would be bound and the second column is for display reference only. Example 010 Catalogs 020 Ignition 030 Brakes 040 Fuel System Any help appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up multiple fields in a list box?
Assume the source as posted is in 2 cols
Assume you're using listbox from Control toolbox Set the ColumnCount to 2 Any good? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "NEWER USER" wrote: I want to display multiple values in a list box or combo box from 2 columns? The first column would be bound and the second column is for display reference only. Example 010 Catalogs 020 Ignition 030 Brakes 040 Fuel System Any help appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up multiple fields in a list box?
I want to reference Column A and Column B on another worksheet in the same
workbook. I believe these must be entered in the Value field on the Properties menu. Any ideas. "Max" wrote: Assume the source as posted is in 2 cols Assume you're using listbox from Control toolbox Set the ColumnCount to 2 Any good? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "NEWER USER" wrote: I want to display multiple values in a list box or combo box from 2 columns? The first column would be bound and the second column is for display reference only. Example 010 Catalogs 020 Ignition 030 Brakes 040 Fuel System Any help appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up multiple fields in a list box?
Just set the ListFillRange to point accordingly to the source range,
eg ListFillRange: Sheet1!A1:B4 where Sheet1!A1:B4 is the source range -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "NEWER USER" wrote: I want to reference Column A and Column B on another worksheet in the same workbook. I believe these must be entered in the Value field on the Properties menu. Any ideas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
| Multiple Fields In Multiple Ranged Pivot Table | Excel Discussion (Misc queries) | |||
| Create a summary list using same fields from multiple sheets | Excel Discussion (Misc queries) | |||
| Auto-Fill in List Fields? | Excel Worksheet Functions | |||
| Can I sort a list with more than three fields? | Excel Discussion (Misc queries) | |||
Linear Mode
