Listbox: ListFillRange

  • Thread starter Thread starter RDK
  • Start date Start date
R

RDK

I'm trying to use a ListBox on an Excel sheet. I have the items which I
want to display in the ListBox in the cells "E15:O15". However, when I
specify this range in the ListFillRange property, the ListBox on the sheet
only displays the first item. If I change the range from a horizontal
range to a vertical (ie "E15:E25") then it displays all of the values in the
ListBox.

I'm using Office 2000. The documentation on ListBox and ComboBox does not
say anything about the ListFillRange being restricted to vertical ranges.

Am I doing something wrong?

Obviously I can work around this problem by re-orienting my data or by using
some VBA code. At this point I'm just curious as to why it doesn't work.

Thanks......RDK
 
The ListFillRange takes the source only through a column and not from
row. You could do the following thing. Select as many cells (11 in you
case) in a column as are in your original row. And then enter th
formula
=TRANSPOSE("E15:E25")
Note that the cells in the column are selected. And the formula goes i
the first cell. Press Control Shift Enter as this is an array formula
Now use this column as the source.

Manges
 
I learnt it the hardway too.

Mangesh

Mangesh....Thanks for the information. It is curious, however, that the
documentation for ListBox and ComboBox do not detail this requirement
for
the range. Thanks again....Rob
Click to expand...
 
Back
Top