aberenguel
Board Regular
- Joined
- Aug 10, 2006
- Messages
- 83
Here is the code i'm working with
Private Sub Worksheet_Change(ByVal Target As Range)
Dim trgtCell As Range
Set trgtCell = Range("c22")
If trgtCell.Text = "Use Address from PNCM verb" Then
MsgBox "ANALYST: Confrim Mainframe is coded."
End If
End Sub
The problem i am having is annoying. Once the target cell = "use Address from PNCM verb" the msgbox appears every time any cell on the spreadsheet changes. I want the msgbox to appear only once (whenever the target cell = "Use address from PNCM verb")
any ideas?
thanks
Private Sub Worksheet_Change(ByVal Target As Range)
Dim trgtCell As Range
Set trgtCell = Range("c22")
If trgtCell.Text = "Use Address from PNCM verb" Then
MsgBox "ANALYST: Confrim Mainframe is coded."
End If
End Sub
The problem i am having is annoying. Once the target cell = "use Address from PNCM verb" the msgbox appears every time any cell on the spreadsheet changes. I want the msgbox to appear only once (whenever the target cell = "Use address from PNCM verb")
any ideas?
thanks