Help on If and Or statement VBA

[ItalianPlatinum]

I have a current VBA that works as intended see below:

    Dim chk

'check if run for today already
If Int(Range("B8")) <> Date Then
    chk = MsgBox("Import ST was not run for today, do you still want to continue?", vbYesNo)
    If chk = vbNo Then
        Exit Sub
    End If
End If

I want to add a second criteria so if B8 or B11 dont equal DATE to trigger that msgbox. i tried so many different combinations with no luck. is there anything easy you can see that would solve my dilemna?

 

[6StringJazzer]

Be careful with your logic. Do you mean

B8 OR B11 don't equal DATE
This means at least one of them does not equal Date

or

B8 AND B11 don't equal DATE
This means neither one of them equals Date

Just a wild guess but I think you want the second one.

If Int(Range("B8")) <> Date And Int(Range("B11")) <> Date Then

 

[ItalianPlatinum]

Maybe unless I am confusing myself I have the below condition

Run date 1: 03/30/22 1:46PM
Run date 2: 03/31/22 5:58PM

so if one of the 2 dont equal todays date to kick a warning

 

[6StringJazzer]

In that case you want

If Int(Range("B8")) <> Date Or Int(Range("B11")) <> Date Then