Combobox/listbox

FSt1 · 01-04-2005, 10:06 AM

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

Andy Brown · 01-04-2005, 11:06 AM

> 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

01-04-2005, 12:06 PM

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

**gocush** · 01-04-2005, 12:15 PM

It appears that you want the Transpose function, but I don't think you can put it directly into the List Fill Range property of your combobox.

You might try creating a Named Range ( Insert/Name/Define), say MyXList. In the RefersTo box at the bottom of this dialog enter =TRANSPOSE(D2:G2).

Then bring up the Properties of your cbo and enter MyXList in the List Fill Range.

Andy Brown · 01-04-2005, 03:06 PM

> 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