Message Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi James,

Change:
If ("A1") = "Yes" Then
Click to expand...

to:

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


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