bound columns - listbox question
Hi Amy
Yes you can have more than one column in a listbox control:
Set Boundcolumn and ColumnCount values to number of columns
To copy values of each column to your sheet:
For i = 1 To 5 'No of cols
Sheets("Feuil1").Cells(1, i).Value = ListBox1.Column(i - 1)
Next i
HTH
Cordially
Pascal
"Amy" a écrit dans le message de
...
is it possible to have more than one bound column in a
listbox? I have a listbox with four columns and i'd like
to copy the value in each column of the listbox to a
seperate columns in a worksheet. can this be done?
thanks
|