Recent content by DougMVP

In your post 14, you said: "I explained in an earlier post that its also possible to do all the following using table/query row sources:" However, the OP did not have a table/query row source. He (and I) had a value list row source and in such cases, there is no query definition that can be...

No, Doug Robbins. To complete the sorting method, I dumped the array into Excel and then sorted it there before loading it back into the list box, using the following code: Dim i As Long, j As Long Dim varlist As Variant Dim xlapp As Object Dim xlbook As Object Dim xlsheet As Object Dim...

Seems like the other respondent never appreciated that the listbox was of the Value List type. I came here looking for the same thing, and have since come up with the following method of loading the data from a mult-column listbox into an array Dim i As Long, j As Long Dim varlist As Variant...