ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 793
- Office Version
- 365
- 2019
- Platform
- Windows
I have a current VBA that works as intended see below:
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?
VBA Code:
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?