I use the following vba for a message alert,
once triggered , is it possible to make it not trigger again for 5 minutes?
once triggered , is it possible to make it not trigger again for 5 minutes?
VBA Code:
Private Sub Worksheet_Alert()
Dim Msg As Long
Dim myRange As Range
Set myRange = Sheet85.Range("z26:z26")
Dim cell As Range
For Each cell In myRange
Evaluate (cell)
If StrComp(cell, "Yes", vbTextCompare) = 0 Then
Msg = MsgBox("" & vbCrLf & " " & Range("h26").Value, vbExclamation)
End If
Next
Set myRange = Sheet85.Range("z27:z27")
For Each cell In myRange
Evaluate (cell)
If StrComp(cell, "Yes", vbTextCompare) = 0 Then
Msg = MsgBox("" & vbCrLf & " " & Range("h27").Value, vbExclamation)
End If
Next
End Sub