use the value chosen from a selection in a combobox and use it for selection in filtering rows

[kbishop94]

I have a combobox that is referencing a long list on a separate workskeet (sheet3) and I want to use the name for what the user chooses and hide all rows that do NOT contain that name/value from a column... Basically, I am wanting to use VBA/activeX with a combobox to do the same thing as filtering

So if "Spray & Forget" is chosen from the list it will filter out everything from the 'customer' column in G that isnt "Spray & Forget".

My code I have so far: (its incomplete and wrong, I know... still very much greeen when it comes to VBA )

Private Sub ComboBox1_Change()    

Range("H1") = ComboBox1.Value
    
    'drop down list for selecting a Customer in order to filter down the list

Dim lCol As Long
    lCol = ActiveSheet.UsedRange.Columns.Count
    rCol = ActiveSheet.UsedRange.Rows.Count

For Each Cell In Range(Cells(10, 1), Cells(rCol, lCol))

Next

End Sub

 

[dmt32]

Hi,
try

Private Sub ComboBox1_Change()
    Range("H1") = ComboBox1.Text
    With ActiveSheet.Range("$A$9")
        .AutoFilter
    If Me.ComboBox1.ListIndex <> -1 Then
        .CurrentRegion.AutoFilter Field:=7, Criteria1:=Me.ComboBox1.Text
    End If
    End With
End Sub

place code in your worksheets code page.

Dave