Input Range for a List Box

[sca723]

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.

[Max]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>