VBA filter from multiple selection drop down list

[npatzke]

Hello,

I am in need of help on creating an activation button for a filter based on the value of another cell.
I currently have a multi-selection drop down box that outputs the selections made into an output cell.
When multiple items are selected, they are divided by a "/" symbol.
I have looked around for a VBA code I could modify to achieve this but cannot find anything.
Can someone please help?

 

[kevin9999]

a VBA code I could modify to achieve this

You could modify this:

Option Explicit
Sub Array_Filter()
    Dim ws1 As Worksheet, ws2 As Worksheet
    Set ws1 = Worksheets("Sheet1")  '<~~ Change to actual sheet name with the 'dropdown' cell
    Set ws2 = Worksheets("Sheet2")  '<~~ Change to actual sheet name with range to be filtered
    
    Dim a
    a = Split(ws1.Range("A2"), "/") '<~~ Change A2 to actual cell with the dropdown with multiple selections
    
    With ws2.Range("A1").CurrentRegion  '<~~ Adjust range to suit your actual data range
        .AutoFilter 1, Array(a), 7      '<~~ Change 1 to whatever column has the values to be filtered
    End With
End Sub