Message Box

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
 
N

Norman Jones

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple data validation 3
Incorpoarting cell contents into a message box 6
Clean-Up Cascading Data Validation List Values 4
List if criteria are met 4
Filling Out Cells Based on Data Validation 1
Advanced conditional formatting 3
conditional format? 1
Popup Input Box 6

Top