bound columns - listbox question

[Amy]

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

 

[Bob Phillips]

Amy,

Yes it is.; Set the columncount property of the listbox to your number of
columns, and set rowsource to the full range.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[papou]

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