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)