bound columns - listbox question
 

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

bound columns - listbox question
 

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)

"Amy" wrote in message
...
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

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