Hi there, was wondering if anyone would be able to help? I have a spreadsheet which I would like, when opened, to display a userform (this bit I have sussed). Within this userform, I would like a list box, or something similar to the drop-down autofilter list which would allow the user to filter a column (in this case column E) rather than do it within the spreadsheet. Any idea if this is doable and if so, how?

Many thanks

You won't be able to get filter arrows on a listbox to use for filtering but you can add a textbox to the form and have the listbox filter as you type in the textbox.
http://elcha-en.blogspot.ca/2016/09/...ox-values.html