mir missfällt mir die riesen "If"-Abfrage und ich bin mir sicher Ihr habt da eine wesentlich elegantere Lösung.
If Me.Material = "10346" Then
arr_no = 0
End If
If Me.Material = "10415" Then
arr_no = 1
End If
If Me.Material = "10618" Then
arr_no = 2
End If
If Me.Material = "11921" Then
arr_no = 3
End If
If Me.Material = "11988" Then
arr_no = 4
End If
If Me.Material = "12391" Then
arr_no = 5
End If
If Me.Material = "12568" Then
arr_no = 6
End If
If Me.Material = "12755" Then
arr_no = 7
End If
If Me.Material = "12758" Then
arr_no = 8
End If
If Me.Material = "13421" Then
arr_no = 9
End If
If Me.Material = "13565" Then
arr_no = 10
End If
If Me.Material = "13779" Then
arr_no = 11
End If
If Me.Material = "13915" Then
arr_no = 12
End If