Is there a way that I can have a message box display when an error is
received while running a Macro?
Vick
Is there a way that I can have a message box display when an error is
received while running a Macro?
Vick
You need to trap the error and display the message. Example
Sub Test()
On Error Goto errHandler
'more code
Exit Sub
errHandler:
Msgbox "some message"
End Sub
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Vick" <[email protected]> wrote in message
news:[email protected]...
> Is there a way that I can have a message box display when an error is
> received while running a Macro?
>
> Vick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks