Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox Question | Excel Worksheet Functions | |||
LIstbox Question | Excel Programming | |||
Listbox with Bound Columns | Excel Programming | |||
Multi-column ListBox. Multiple bound columns??? | Excel Programming | |||
Listbox question | Excel Programming |