Question : rais error vba
Answered by : braxton-bell
Sub TestRaiseError()
On Error GoTo eh
If Range("A1") <> "Fred" Then
Err.Raise vbObjectError + 1000, , "The text in the cell A1 should say Fred."
End If
Exit Sub eh:
MsgBox "User Error: " & Err.Description
End Sub
Source : https://www.automateexcel.com/vba/throw-raise-error-err-raise/ | Last Update : Wed, 22 Jun 22