I am trying to make a Macro stating if a certain cell value is less than 20 AND check box is unchecked then MsgBox.
Here is what I have but cant make it work.
If Range ("G9"). Value <25 AND CheckBox3.Value = False Then
MsgBox "Service Required"
End If
End Sub
The first part of if value of cell work. I however cant get it to work with the checkbox as an and.
Thank you in advance
Here is what I have but cant make it work.
If Range ("G9"). Value <25 AND CheckBox3.Value = False Then
MsgBox "Service Required"
End If
End Sub
The first part of if value of cell work. I however cant get it to work with the checkbox as an and.
Thank you in advance