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