| 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 |
| 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 | |||
Threaded Mode
