Multicolumn ListBox Output

[mdsmith]

Hello!

I'm using a multicolumn Listbox on a userform and i'm trying to understand how excel/vba deals with the data stored there. Ideally i'll have the user make a selection from the listbox and have it output to some cell/range but I have not been able to get it to work using the same method as my single column listboxes.

Does excel treat each row as a single piece of data or is each column in the row treated as such? Just looking for some general help. Thanks in advance!

[Norie]

Each column is treated individually.

You can extract the data from the selected row like this.

It puts the data in the next available row starting at column A.

Please Login or Register  to view this content.