I would like to create a macro which checks at the beginning if a certain cell has a value. if the cell has a value the macro carries on running as normal, if the cell is blank, a message comes up to tell the user that 'the data isn't verified....' or something like that. help! how do i do this?
thanx to anyone who can help me. chiao,
dj_dafad
p.s. is it something along the lines of this:
Dim wrong
If Range("d20") = 0 Then
wrong = MsgBox("you have not verified that all of the data entered is correct",
vbExclamation,"verify")
GoTo FINISH
End If
thanx to anyone who can help me. chiao,
dj_dafad
p.s. is it something along the lines of this:
Dim wrong
If Range("d20") = 0 Then
wrong = MsgBox("you have not verified that all of the data entered is correct",
vbExclamation,"verify")
GoTo FINISH
End If