Excel VBA Cell Validation

[SamByPublicDemand]

Is there a way to check with VBA whether a certain cell is filled? I need a message box to pop up warning the user if cell B2 is not filled in before continuing with the rest of the macro, but I have no idea where to start, any help? Thank you in advance.

 

[Jonmo1]

Welcome to the board..

Try

If Range("B2") = "" Then
    MsgBox "You must enter data in B2"
    Exit Sub
End If

 

[SamByPublicDemand]

Thanks.

Also is it possible to make it check for that cell in Sheet2 rather than the active sheet just incase someone runs the macro whilst not in Sheet2.

 

[Jonmo1]

Try

If Sheets("Sheet2").Range("B2") = "" Then
    MsgBox "You must enter data in Sheet2!B2"
    Exit Sub
End If

 

[SamByPublicDemand]

Thank you, that works fine, is there a way to check multiple cells using the same code? Specifically B1, B18, B20 and B22 in sheet 2 are not empty, and check B1 in sheet 3 contains a certain string?

 

[SamByPublicDemand]

Oh also, the rest of the code runs even after the message box comes up, here is the current code :

Sub CheckMaster()

If Sheets("Sheet2").Range("B1") = "" Then
    MsgBox "You must enter data in Sheet2!B2"
    Exit Sub
End If
End Sub

If the cells are blank, then the code is not run, and if the cell is filled, it carries on.

 

[Jonmo1]

Try

<font face=Error: Key or Value Not Found.><SPAN style="color:#00007F">Sub</SPAN> CheckMaster()<br><br><SPAN style="color:#00007F">With</SPAN> Sheets("Sheet2")<br>    <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> c <SPAN style="color:#00007F">In</SPAN> .Range("B1, B18, B20, B22")<br>        <SPAN style="color:#00007F">If</SPAN> c = "" <SPAN style="color:#00007F">Then</SPAN><br>            MsgBox "You must enter data in Sheet2!" & c.Address<br>            <SPAN style="color:#00007F">Exit</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br>        <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br>    <SPAN style="color:#00007F">Next</SPAN> c<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br><br><br></FONT>