Thread: Narrowing Data Listbox

Hey!

I've got this worsheet i'm trying to create. I've got everything i need except getting the search form (UserForm2) to load data into UserForm1.

I have a small form that opens with 2 listboxes. I can pull info into both boxes from column A and B, but i want the info from column B to be dependant on column A. Such as, one of my customers is Advanced. I want to be able to choose Advanced on listbox 1, and then only see the cities from Advanced in listbox 2 according to the database (sheet2), instead of the whole column.

Then i need to load that row of data into UserForm1 in the right boxes so i can view it.

I've searched around for hours, but i dont really know what it would be called...

Any help would be awesome! thanks!