Displaying the header on a userform Listbox

Hello,

I'm trying to populate a ListBox from a data from a worksheet based on a criteria. Whilst I managed to display the intended result, that is the list of corresponding criteria, I cannot manage to display the header of the data and I'm not sure how should I rewrite the code to include the header.

The header is on the Row 7 and the data starts from Row 8.

Do I have to look at the exercise from a different angle or is there any way I can display the header in teh result by amending/updating the code below?

Thank you as always for your help and contribution.

Below is the code used:

Please Login or Register  to view this content.

The add headers apparently only works with the 'rowsource' method of loading the listbox.
attached file to show.
torachan.

Another way is to insert another listbox and then populate the header into it.
You may need to set enabled property to false & also adjust some other properties.
Here's an example:

Hello everyone,
Thank you very much for your contribution and help.
I sort of used both recommendations but doing the search outside the userform and pasting the result into the listbox. It worked very well.
Thank you very much.