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