AW: Listbox filtern "größer/kleiner als" und Bereich
04.01.2017 17:38:04
Matthias
Vielen Dank für die schnelle Hilfestellung, jedoch habe ich Probleme mit dem Umstellen. Wie mü _
sste der Code nun vollständig aussehen?
Public chk As Boolean
Sub checkit()
Dim ar(5) As Variant, objMyDic As Object, I As Long, F As Long, tempStr1 As String, tempStr2 _
As String, tempStr3 As String, IntC As Integer, row_ As Integer
Dim ArCol(4)
ArCol(0) = 1
ArCol(1) = 2
ArCol(2) = 3
ArCol(3) = 4
ArCol(4) = 4
Set objMyDic = CreateObject("Scripting.Dictionary")
If chk = True Then
ContListfeld.Clear
For I = 1 To 5
If Controls("Cont" & I).Value = "" Then ar(I - 1) = "*" Else ar(I - 1) = Controls("Cont" & I) _
.Value
tempStr1 = tempStr1 & ar(I - 1) & "/"
Controls("Cont" & I).Clear
Controls("Cont" & I) = IIf(ar(I - 1) = "*", "", ar(I - 1))
Next
For IntC = 1 To 5
For I = 2 To Tabelle1.Cells(Rows.Count, 1).End(xlUp).Row
tempStr2 = Tabelle1.Cells(I, "A") & "/" & Tabelle1.Cells(I, "B") & "/" & Tabelle1.Cells(I, " _
C") & "/" & Tabelle1.Cells(I, "D") & "/" & Tabelle1.Cells(I, "D") & "/"
If Tabelle1.Cells(I, 1) = Cont1.Text Or Cont1.ListIndex = -1 Then
If Tabelle1.Cells(I, 2) = Cont2.Text Or Cont2.ListIndex = -1 Then
If F * Tabelle1.Cells(I, 3) >= F * Val(Cont3.Text) Or Cont3.ListIndex = -1 Then
If Tabelle1.Cells(I, 4) >= Val(Cont4.Text) Or Cont4.ListIndex = -1 Then
If Tabelle1.Cells(I, 4)