close
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 quot;some messagequot;
End Sub
--
HTH
RP
(remove nothere from the email address if mailing direct)quot;Vickquot; gt; wrote in message
news
gt; Is there a way that I can have a message box display when an error is
gt; received while running a Macro?
gt;
gt; Vick
全站熱搜
留言列表
