View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amelia Amelia is offline
external usenet poster
 
Posts: 24
Default 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!