Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MsgBox when an Error occurs
Is there a way that I can have a message box display when an error is
received while running a Macro? Vick |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MsgBox when an Error occurs
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" wrote in message ... Is there a way that I can have a message box display when an error is received while running a Macro? Vick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MsgBox compile error in Excell | Excel Discussion (Misc queries) | |||
Compile error for MsgBox copied from Microsoft training example? | Excel Discussion (Misc queries) | |||
MsgBox with condition and showing details | Excel Worksheet Functions | |||
display cell value in msgbox formatted as % | Excel Discussion (Misc queries) | |||
Msgbox | Excel Worksheet Functions |