Combobox/listbox
 

happy new year to all,
I have a problem with combo boxes/list boxes.
I can get the list fill range to display data in a column
such as D2:D5 but i can't get the list fill range to
display data in a row such as D2:G2. when i set the list
fill range to D2:G2, all the combo/list box displays is
the data in D2. Is there a way to get the combo/list box
to display data in a row.
any help would be appreciated.
thanks in advance.
FSt1

Is there a way to get the combo/list box
to display data in a row.

Assuming you've set ColumnCount to 4, try setting ColumnWidths. The default
width for Column1 may exceed the width of the listbox, already.

HTH,
Andy

thanks andy but that didn't work like i wanted.
I want the row info to appear in the box in column format.
but i do appreciate the responce.
thanks again.
FSt1
-----Original Message-----
Is there a way to get the combo/list box
to display data in a row.

Assuming you've set ColumnCount to 4, try setting
ColumnWidths. The default
width for Column1 may exceed the width of the listbox,
already.

HTH,
Andy


.

I want the row info to appear in the box in column format.

You want the data from a horizontal range in the worksheet to populate a
single column? Try AddItem in the Initialize event of the form, eg:

Private Sub UserForm_Initialize()
ListBox1.AddItem Range("Sheet1!D2")
ListBox1.AddItem Range("Sheet1!E2")
ListBox1.AddItem Range("Sheet1!F2")
ListBox1.AddItem Range("Sheet1!G2")
End Sub

HTH,
Andy