ExcelNovice
Well-known Member
- Joined
- May 12, 2002
- Messages
- 583
The following macro works fine, except that I have to click OK two times to close the msg box, can anyone say why this is so?
This is the script:
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("ax84").Value = "" Then
MsgBox "Please enter your reason before continuing."
End If
End Sub
This is the script:
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("ax84").Value = "" Then
MsgBox "Please enter your reason before continuing."
End If
End Sub