ListBox with Horizontal Values  
Author Message
suket





PostPosted: Mon Mar 26 18:20:45 CDT 2007 Top

worksheet functions >> ListBox with Horizontal Values

I have a named Range that containts horizontal column headings on one
sheet and I want to have a list box (where users can just click the
column they desire) and then calculations adjust accordingly. When I
insert the ListBox into my other sheet and select ListFillRange
"MyNamedIndex" it only inserts the first column but none of the others
in the horizontal row.

Thanks for the help.

Scott

Excel42  
 
 
Max





PostPosted: Mon Mar 26 18:20:45 CDT 2007 Top

worksheet functions >> ListBox with Horizontal Values Consider using a DV droplist instead.
It works even with a horiz named range.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


> I have a named Range that containts horizontal column headings on one
> sheet and I want to have a list box (where users can just click the
> column they desire) and then calculations adjust accordingly. When I
> insert the ListBox into my other sheet and select ListFillRange
> "MyNamedIndex" it only inserts the first column but none of the others
> in the horizontal row.
>
> Thanks for the help.
>
> Scott