running a macro only if criteria are met

[The Grinch]

hello all,

I have a macro that runs fine, the problem is it relies on user input
and will run even if the data received is invalid. I can calculat
simple checks to confirm if the user has inputted valid data, an
simply set a test cell to either "YES" or "NO".

Is there any way I can amend the macro such that if the cell reads "NO
the macro stops and gives the user a relevant message, and if the cel
reads "YES", the macro runs through as normal.

any help/comments will be appreciated.

CHEER

 

[Pete McCosh]

Try something like this, although you could just use the
test criteria in the IF statement, rather than checking a
cell value.

If Sheets("Sheet 1").Range("A1").Value = "No" Then
MsgBox(Invalid data Input.")
Exit Sub
End If

Cheers, Pete.