| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Filling a List Box in Excel from an Array
Another example.
Dim strArray(2) As String strArray(0) = "X" strArray(1) = "Y" strArray(2) = "Z" ListBox1.List = strArray Cheers Andy Martin wrote: Hope someone can help. I have a listbox in excel which I am trying to populate from an array. The array is picking up certain values from a sheet depending on a previous value selected in another list box. I currently have the array code in a module. regards, Martin -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel array formulas | Excel Discussion (Misc queries) | |||
| Can't publish Excel list to Sharepoint | Excel Discussion (Misc queries) | |||
| Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) | |||
| Excel 2003: Match one list against another and highlight differenc | Excel Worksheet Functions | |||
| Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions | |||
Threaded Mode
