Message Box
 

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

Message Box
 

Hi James,

Change:

If ("A1") = "Yes" Then

to:

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


BTW it is rarely necessary or desirable to make selections. Therefore, you
could dispense with the line:

Range("A1").Select

---
Regards,
Norman



"James Hamilton" wrote in message
...
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