Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 column List Box populated with data not from Excel sheet?
Hello,
I would like to populate a listbox with 2 columns of data. This data is in an array called FirmNames. This is how I am doing it currently With FirmList For i = 1 To NumFirmNames .AddItem (CStr(FirmNames(i).FirmName & vbTab & FirmNames(i).Selected)) Next i End With However, the problem is that the FirmNames have different lengths, so the second column does not line up. I am much more familiar with forms in Access, and would like to do something similar to the following: For i = 1 To NumFirmNames rowString = rowString & CStr(FirmNames(i).FirmName) & "; " & FirmNames(i).Selected & "; " Next i FirmList.RowSource = rowString (The column count property is set to 2). However, this gives me a syntax error in Excel because the rowSource property here seems to be a range on the Excel worksheet. Any help would be greatly appreciated. Thanks, Mariah |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 column List Box populated with data not from Excel sheet?
I have the column widths set. The problem is I don't know how to get
the data into 2 different columns. What I am doing now puts both FirmNames(i).FirmName and FirmName(i).Selected into the same column. JLGWhiz wrote: You can set the column width with the ColumnWidths Property. See VBA Help for details. "MariahJ" wrote: Hello, I would like to populate a listbox with 2 columns of data. This data is in an array called FirmNames. This is how I am doing it currently With FirmList For i = 1 To NumFirmNames .AddItem (CStr(FirmNames(i).FirmName & vbTab & FirmNames(i).Selected)) Next i End With However, the problem is that the FirmNames have different lengths, so the second column does not line up. I am much more familiar with forms in Access, and would like to do something similar to the following: For i = 1 To NumFirmNames rowString = rowString & CStr(FirmNames(i).FirmName) & "; " & FirmNames(i).Selected & "; " Next i FirmList.RowSource = rowString (The column count property is set to 2). However, this gives me a syntax error in Excel because the rowSource property here seems to be a range on the Excel worksheet. Any help would be greatly appreciated. Thanks, Mariah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Drop Down Box populated by a List | Excel Discussion (Misc queries) | |||
How do I insert a work sheet populated with data into another? | Excel Worksheet Functions | |||
Drop-down list Populated by a Subset of a larger list | Excel Worksheet Functions | |||
Having data automatically populated in a different sheet | Excel Worksheet Functions | |||
detect column name of last populated data | Excel Programming |