That does the trick, thank you! seems so simple, I suspected it would be but couldn't nail it down.
The whole list box contents is what I needed, the filtering is done on the userform.

A small adjustment if possible, the list box doesn't have headers, but the database it pulls from does, could I have the headers added into the exported file? Could we also size the columns in the workbook to fit the data?