2d array sort and load to list box

[SPARKY347]

new at working with arrays hoping someone can help me heres what im trying to do. i would like a 2d array that loads 2 columns. column 1 = first names, column 2 = last names, i then would like to load these 2 columns into 2 seperate list boxes. with the list boxes i would like to then be able to sort the list boxes based on the value in the other list box.

example from workbook= if i select allan in 1 list box i would like the array to sort and put BOTH his first and last name at the top of both list boxes i know this is possible just not how to code it.

i do know how to add the values into the list boxes and work with the list box but am completely lost when it comes to the possibilities of arrays

[mikerickson]

I think the attached will do what you want.

Each list box holds both names, but with a different column hidden.

The SortListBox sub will sort a list box by the column indicated (defaults to column 0)

The ListBoxes are connected via Change event so that the selecting a name in one list box will select the matching name in the other list box.

Pressing the added button will move the selected name to the top of both list boxes.

Please Login or Register  to view this content.

[SPARKY347]

that is excalty what i needed thank you

[SPARKY347]

one more thing sorry, see attached is it possible to add 1 more list box infront of the first name list box, call it member # list box

[SPARKY347]

Sorry I should have also mentioned I don't really need the buttons for the move to top and sort by last and first

[mikerickson]

The third listbox is a minor tweak, but I don't understand why no buttons.

When do you want the list sorted?
When do you want the selected name to move to the top?

Also, if these three list boxes are going to be completely synchronized, it would be much simpler to just have a single listbox showing all three columns.

[SPARKY347]

How can I do the single lost box? Sorry regarding the sorting I don't really need it sorted I guess. Using the combo box works great. As I select a value it grabs the other ones at the same time which is exactly how I want t it