Array returning only first item

I have a worksheet table with contacts ("Leads"). I also have a userform to interact with the list ("FormInputs"). On the userform is a Listbox ("ContactList").

When I filter the list for say, "medical" contacts or "client" contacts, the listbox is re-populated with only the filtered results/visible contact names & respective row numbers.

I'm a fairly proficient leach of other people's code but I have copied, pasted, cut and added so much I no longer know what I'm doing. On top of that, arrays are something I can never seem to get my head around. Is there something simple someone can point out that I'm doing wrong? And please don't say the thing I'm doing wrong is "messing with code". My feelings will be hurt and I'll never be able to lie to others about how great I am . . .

Thank you all!

Please Login or Register  to view this content.

Thank you for the info Glenn. My profile was a 'little' outdated. Apparently I had not updated it since Excel 2003. I have updated it now.

Thank you, beyond Excel. I am playing with your solution now, testing on different filters, etc. Thank you for taking your valuable time to help me!
Sincerely,
David

Even though beyond Excel beat you to it, thank you bsalv for taking the time to help me. It lends credence to the solution that both of you had the same idea.

Sincerely,
David

That is a very kind offer, sintek. At this point though, I think beyond Excel & bsalv have a solid solution. If someone starts giving me alternatives now, my head would explode.

I do appreciate the offer though!

Sincerely,
David

I have been playing with the solutions given by beyond Excel & bsalv.

Initially, I thought the two were the same, but after actually reading through them, I see that they are not. I tried both solutions and have to say, bsalv's solution was easier for my brain to understand and it worked straight "out of the box". I got a little confused with beyond Excel's solution at the point of adding my filter because I have several filters which are dependent on other selections.

For me and my situation, I am going with bsalv's solution as the solution.

Regardless, both were very kind to help me and I genuinely appreciate it.

Sincerely,
David