Filtering column for input in ListBox

[Kristina96]

Hello everyone.

I have a document with a userform that allows users to select a specific area in a list box. Multiple selections are possible.
Based on the input I would like to filter column E called "AreaColumn" for the input made by a user when cofirming the user form with OK.

So far I've tried something like this:

Private Sub OKButton_Click()
ActiveSheet.Range("AreaColumn").AutoFilter Field:=1, Criteria1:=ListBox1.Value
End Sub

Unfortunately it does not bring the desired result but simply doesn't change the situation.
Could you help me with that?

Thank you in advance and best regards,
Kristina

 

[Fluff]

Ok, this is now a different question to your op, so you will need to start a new thread.
When you do, you will need to give far more information, please remember that we cannot see your data & we have no idea what "all other possible selections" could be.
Thanks