| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
message box keeps popping
I would like to make the message box pop automatically when cell G24="pop".
But the message keeps popping when i click to anywhere in the worksheet. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Range("G24").Value = "pop" Then Msg = MsgBox("Both Values do not agree", vbOKOnly) End If End Sub Thanks for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Popping out Message Box! | Excel Discussion (Misc queries) | |||
| What's with this MS message that keeps popping up? | Excel Programming | |||
| message box popping up when the selection of a Form combo box changes | Excel Programming | |||
| How to stop message popping up before open the excel? | Excel Discussion (Misc queries) | |||
| broken links message still popping up | Excel Discussion (Misc queries) | |||
Threaded Mode
