Hello Again,

Maybe I should have stated earlier that I'm actually checking 5 groups of 2 cells (if that makes since). The code should check A1 & B1, then A2 & B2, A3 & B3...

What happens is that if A1 has data, but B1 doesn't. The code returns the 1st error message as expected, butwhen the ok button is pushed on the 1st message it goes to the next successful message, which I don't want it to do until all cell conditions are true.

Here's the code for just 2 of the 5 groups needed:

Sub Check_click()

If Range("A1").Value <> "" And Range("B1").Value = "" Then
MsgBox "You must select a code in Special Purpose Deposits. Click the arrow to select General or Building!", 16, "message"
Range("B1").Select
End If

If Range("A2").Value <> "" And Range("B2").Value = "" Then
MsgBox "You must select a code in Special Purpose Deposits. Click the arrow to select General or Building!", 16, "message"
Range("B2").Select

Else
MsgBox "Check Sheet is Successful. Go to step 5!", 64, "message"
End If

End Sub

Thanks Again,
EMoe