VBA If cell is blank, then message box and exit sub, otherwise continue macro

[Will85]

I have what I thought was easy enough, but I am struggling with the syntax.

I want my macro to check if a cell is blank before running the rest of the code. If the cell is blank, then pop up a message box and stop the rest of the macro, if its not blank, then continue the macro.

I am not sure what to put between Exit Sub and My code for the macro I want to run.

If Worksheets("Instructions").Range("C3").Value = "" Then
MsgBox "Missing Date"
Exit Sub


My code
End Sub

 

[Joe4]

You are pretty close. Something structured like this would work:

Sub Macro1()

    If Worksheets("Instructions").Range("C3").Value = "" Then
        MsgBox "Missing Date"
        Exit Sub
    End If

    My code

End Sub

 

[Will85]

Thank you, that appears to be working. I could have sworn I tried that, but it was still going through the rest of the code even though its blank. Possible I accidently was using an Else statement.

Thank you.

 

[Joe4]

Thank you, that appears to be working. I could have sworn I tried that, but it was still going through the rest of the code even though its blank. Possible I accidently was using an Else statement.

Thank you.

An else statement should work fine too, if structured correctly i.e.

Sub Macro1()

    If Worksheets("Instructions").Range("C3").Value = "" Then
        MsgBox "Missing Date"
        Exit Sub
    Else
        My code
    End If

End Sub

Where you can get it to trouble is if C3 is not really blank.
If it is something like a single space, " " is not the same as "", so your code would interpret that as something.

 

[Will85]

An else statement should work fine too, if structured correctly i.e.

Sub Macro1()

    If Worksheets("Instructions").Range("C3").Value = "" Then
        MsgBox "Missing Date"
        Exit Sub
    Else
        My code
    End If

End Sub

Where you can get it to trouble is if C3 is not really blank.
If it is something like a single space, " " is not the same as "", so your code would interpret that as something.

Would there be a better way to structure it, so that it only accepts a true date. Right now I am just trying to make sure a user remembers to input something into the cell, but I suppose they could enter jibberish or mess up the date.

Is there a way for it to tell if the value is an actual date value?