Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I control where the input message appears? | Excel Discussion (Misc queries) | |||
Adding an error message at close of file when criteria are met | Excel Discussion (Misc queries) | |||
Calculations And Order In Macros | Excel Discussion (Misc queries) | |||
when opening excel I receive a message that says file can't be fo. | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions |