Sub Filteren()
Range("A8:B22").Select
Selection.AutoFilter
ActiveSheet.Range("$A$8:$B$22").AutoFilter Field:=1, Criteria1:="*" & ActiveSheet.Range("A2").Value & "*", _
Operator:=xlAnd
End Sub
Private Sub CommandButton1_Click()
listboxen
End Sub
Private Sub listboxen()
Filteren
Dim A
A = 8
Volgende:
A = A + 1
If Sheets("blad1").Cells(A, 1) <> "" Then
GoTo Volgende
Else:
A = A - 1
ListBox1.RowSource = "Blad1!A9:A" & A
End If
End Sub
Range("A8:B22").Select
Selection.AutoFilter
ActiveSheet.Range("$A$8:$B$22").AutoFilter Field:=1, Criteria1:="*" & ActiveSheet.Range("A2").Value & "*", _
Operator:=xlAnd
End Sub
Private Sub CommandButton1_Click()
listboxen
End Sub
Private Sub listboxen()
Filteren
Dim A
A = 8
Volgende:
A = A + 1
If Sheets("blad1").Cells(A, 1) <> "" Then
GoTo Volgende
Else:
A = A - 1
ListBox1.RowSource = "Blad1!A9:A" & A
End If
End Sub