View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Papou Papou is offline
external usenet poster
 
Posts: 56
Default 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