Exit sub and message box based on certain conditions

[howard]

I have the following snippet of code below

 Sheets("recon").Select
If Range("d8") = 0 Then
MsgBox "No JNL required"
Exit Sub
End If

I would like it amended so that if range D8 or D9 is 0, then message box to be activated and message to say "No JNL required" and Macro to exit

If range D8 or D9 is not zero, then message box to state "JNL uploaded and ready to be imported"




Your assistance in amended the code is most appreciated

 

[My Aswer Is This]

Try this:

Sub For_Howard()
'Modified  11/9/2018  1:41:42 AM  EST
Sheets("recon").Select
If Range("D8") = 0 Or Range("D9").Value = 0 Then MsgBox "No JNL required": Exit Sub
If Range("D8") <> 0 Or Range("D9").Value <> 0 Then MsgBox "JNL uploaded and ready to be imported"
End Sub

 

[howard]

thanks for the help, code works pefectly

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

thanks for the help, code works pefectly