Hi,

I want a message box to appear (VB OKonly) if the value of a cell is either
Yes or No.

My code is:

Range("A1").Select
If ("A1") = "Yes" Then

MsgBox "THE REPORTS HAVE BEEN UPDATED", , "INFORMATION"

End If

Note: the Yes or No is selected using a data validation list.

HELP! Thanks