Combobox/listbox

[FSt1]

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 D25 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

 

[Andy Brown]

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

 

[Guest]

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

 

[Andy Brown]

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