Populating Listbox based on ComboBox selection - VBA

[JackDomino1]

Hi,

Im looking to populate a list box (5 coloums) based on the selection a user makes in a combobox.

However, the options in the combobox are not unique, so there will be multiple sets of data to display.

Name	Age	Hair Colour
Jack	34​	Brown
Ben	23​	Blonde
Steve	45​	Grey
Jack	65​	Black
John	19​	Black
Ben	21​	Brown

Names are select-able in the combobox. But if the user selects "Jack", the lstbox needs to display two rows of data.

I have managed to make it return the information associated to the first entry which matches the selection criteria, but I am struggling to get it to work on multiple entries.

Thanks

 

[Fluff]

A common problem is leading/trailing spaces, either in the data the combo looks at, or the data your trying to load to the listbox.

 

[JackDomino1]

A common problem is leading/trailing spaces, either in the data the combo looks at, or the data your trying to load to the listbox.

Spot on!!! There was a trailing space! Its working perfect now.
Thank you for your patience. Glad that is working.

Thanks again

 

[Fluff]

Glad to help & thanks for the feedback.