Kristina96
New Member
- Joined
- Sep 30, 2019
- Messages
- 33
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:
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
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:
VBA Code:
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