Selection.AutoFilter Field:=2, Criteria1:="355"
Wie macht man das? Kann jemand helfen?
Private Sub CommandButton1_Click()
Dim Filter As Integer
Filter = CInt(InputBox("Filterkriterium:", "Filterkriterium erfassen", 355))
ActiveSheet.Range("A6:C30").AutoFilter Field:=2, Criteria1:=Filter
End Sub
viele Grüße
Herby
Private Sub CommandButton1_Click()
Dim Filter As String
Filter = CStr(InputBox("Filterkriterium:", "Filterkriterium erfassen", "
viele Grüße
Herby