AW: Mehrere Checkboxen in Schleife Abfragen
01.01.2023 22:21:28
Beno29
Hey könntest du vielleicht nochmal schauen.
wollte in der msgbox die Schrift Farbe ändern mmmh
Option Explicit
Private Declare PtrSafe Function GetSysColor Lib "user32" (ByVal nIndex As Long) As Long
Private Declare PtrSafe Function SetSysColors Lib "user32" (ByVal nChanges As Long, lpSysColor As Long, lpColorValues As Long) As Long
Private Const COLOR_WINDOWTEXT As Long = 8
Private Const CHANGE_INDEX As Long = 1
End Sub
Private Sub CommandButton1_Click()
Dim z
For z = 9 To 1000
If Range("I" & z) = "X" And Range("J" & z) Date Then
Range("G" & z) = Range("G" & z) + 1
Range("J" & z) = Date
If Range("G" & z) >= Range("H" & z) Then Range("I" & z) = ""
Dim defaultColour As Long
'Store the default system color
defaultColour = GetSysColor(COLOR_WINDOWTEXT)
'Set system color to red
SetSysColors CHANGE_INDEX, COLOR_WINDOWTEXT, vbRed
If Range("G" & z) >= 8 Then MsgBox "Neuen Lagerplatz vergeben", vbInformation + vbOKOnly, "Lagerplatz Voll !"
End If
Next z
End Sub