ListBox2 is determined by finding the selection in Listbox1 on MyLists!A:A and returning data in all cells to the right
When ListBox1 selection = the value in A3
Please Login or Register to view this content.
RadRng correctly = "MyLists!$B$3:$E$3"
But ListBox2 only shows the value in B3 and NOT C3, D3 and E3
Hello Carstowal,
The range is a 2-dimensional array. The default setting for a ListBox is a 1-dimensional array. Change the ColumnCount property to match the number of columns in the Range. In your case change it to 4 to display the range "MyLists!$B$3:$E$3".
Sincerely,
Leith Ross
that works, but the data is displayed in 4 columns
B3 C3 D3 E3
the user will have to scroll over to find what she wants.
is there a way to transpose the data to list vertically, such as:
B3
C3
D3
E3
edited:
just figured this out:
SelectMatl.ListBox2.List = Application.Transpose(Range(RadRng).Value)
unless there's a better way!
THANKS FOR THE HELP LEITH
Last edited by carsto; 07-25-2008 at 02:01 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks