Populate a second list box from a worksheet range based on a selection from a different listbox on same userform

[rharri1972]

THIS IS A DUPLICATED QUESTION... I didn't know exactly how to ask for the results I am looking for in previous questions.... please allow this to go through.

Is it possible to find and activate a certain worksheet based on a selection made from a listbox (Listbox1). Listbox1 has multiple columns but I want to reference the certain worksheet from data in the first column of the listbox which is Customer ID. Listbox1 has over 400 rows of customers. I have the multiselect property set to single. It will be the highlighting of or (single click) that would execute the subroutine.

example can be: Customer ID = ABC123 the worksheet would also be named ABC123.

I hope i have learned enough and have enough info on my cheat sheets to then populate another listbox on the same userform with a range of cells on the "ACTIVE WORKSHEET".

Also, there will be no need to clear the second Listbox at anytime as I want to see the information each time listbox1 is moved to a different customer.

As I stated, I have asked for help on this already, but didn't know quite how to ask for the help without scrambling everyone's minds. If this is possible, I would appreciate any help! Although

I have asked for help on here I have also tried doing my own research to no avail.

Thanks for any help!!

 

[Fluff]

Duplicate to: list box selection

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.