Add list of items from named range "Comp" to ListBox1

Hi

I am trying to write code that will populate my ListBox when a cell, named "FilterCell" changes
I have a list of companies, named range "Comp", that expands / reduces with whatever value is entered in "FilterCell"

May I ask for assistance with the code I have written so far -

Please Login or Register  to view this content.

Much appreciated!

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M