here's the code and this is not working.

error message: Expected: =

If Worksheets("sheet5").Range("c6") = " " Then MsgBox("Fill in the
Missing Information!", vbOK, "Warning")

End If
If Worksheets("sheet5").Range("c7") = " " Then MsgBox("Fill in the
Missing Information!", vbOK, "Warning")
End If
If Worksheets("sheet5").Range("c8") = " " Then MsgBox("Fill in the
Missing Information!", vbOK, "Warning")
End If
If Worksheets("sheet5").Range("c9") = " " Then MsgBox("Fill in the
Missing Information!", vbOK, "Warning")
End If


--
tweety127
------------------------------------------------------------------------
tweety127's Profile: http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=545970