VBA Excel - List box only populating one result

I dont usually add requests on here, but after trawling everywhere, I can't seem to find an answer and this really baffling me!

I have a form that is populating data from a seperate spreadsheet which connects to a sharepoint site using a web query.

My script filters the data and returns the results into a listbox.

Everything seems to work fine, but when I filter two fields it will only return a single result and not the list of data. I have stepped through the code and it is filtering correctly, just not displaying the results.

The most confusing thing is I have the exact same code with only one filter on a different page of the form that returns the data correctly.

The working code is:

Please Login or Register  to view this content.

This returns the full list in my listbox 'ActiveListBox', however the below code will only return the first result:

Please Login or Register  to view this content.

I'm really stuck with this and would really appreciate any help!!!

Thanks Paul

I've tried to populate this to a msgbox before setting it as the value of the Listbox, but I got a debug error

Thanks.

It contains multiple rows of data, so it does appear to be capturing it correctly, just not transferring it to the listbox,

yet with one filter it does???

That's great,

I can't try it untill monday when I return to work, but I understand the logic behind it and should be fine now!

I will most like copy the data prior to importing to the listbox!

Thanks for your help!

Paul