|
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. |
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. |
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. |
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 |
| All times are GMT +1. The time now is 07:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com