Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Directly jump to ErrorHandler: stop
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Directly jump to ErrorHandler: stop
Resolved · Low Priority · Version 2010
Reply Wed 21 Dec 2011, 16:09Delegate Julie said...
Julie has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Directly jump to ErrorHandler: stop
Hey there, I really need your help please.
We did one project using vba, but after running, it directly jump to ErrorHandler:(stop became yellow colour)
On Error GoTo 0
Exit Sub
ErrorHandler:
Stop
Resume
If ExcelErrorHandler("Public Sub ArrayB") = True Then Resume Next
End Sub
So I am not sure where is wrong? Could you help me please?
Thank you!
Regards
Julie
For upcoming training course dates see: Pricing & availability
RE: directly jump to ErrorHandler: stop
Hi Julie, thanks for your query. Try re-writing like so:
***
On Error GoTo Errorhandler:
<Your code here>
Exit Sub
ErrorHandler:
If ExcelErrorHandler("Public Sub ArrayB") = True Then Resume Next
End Sub
***
Hope this helps,
Anthony
Reply Thu 22 Dec 2011, 19:32Delegate Julie said...
RE: directly jump to ErrorHandler: stop
Hey Anthony,
Thank you very much indeed!
Merry Xmas and Happy New Year!
Julie
|