Input Range for a List Box
 

I am trying to create a list box. View -- Toolbars -- Forms -- List
Box. I insert a List Box on the worksheet, Right Click on Format
Control and then Control. In the Input Range, I want to enter a range
of cells (A1:Y1). This is not a list, it is a range in a row. But the
List Box does not work using this option. If I use cells A1:A25 i.e.
all values in same column, then the list box works. But I need to use
the values from same row. What am I doing wrong here?

Thanks.


--
sca723
------------------------------------------------------------------------
sca723's Profile: http://www.excelforum.com/member.php...o&userid=28735
View this thread: http://www.excelforum.com/showthread...hreadid=484283

Input Range for a List Box
 

Perhaps a work-around would be to transpose A1:Y1 into a vertical "columnar"
range in say, Z1:Z25, then set the input range to this vertical range

We could put in Z1: =INDEX($A$1:$Y$1,ROW(A1))
and copy down to Z25 to quickly derive the transpose (just one way)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"sca723" wrote in
message ...

I am trying to create a list box. View -- Toolbars -- Forms -- List
Box. I insert a List Box on the worksheet, Right Click on Format
Control and then Control. In the Input Range, I want to enter a range
of cells (A1:Y1). This is not a list, it is a range in a row. But the
List Box does not work using this option. If I use cells A1:A25 i.e.
all values in same column, then the list box works. But I need to use
the values from same row. What am I doing wrong here?

Thanks.


--
sca723
------------------------------------------------------------------------
sca723's Profile:
http://www.excelforum.com/member.php...o&userid=28735
View this thread: http://www.excelforum.com/showthread...hreadid=484283