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.