<

Basic Error Handling code for VBA and Microsoft Office

Posted on
29,892 Points
592 Views
3 Endorsements
Last Modified:
Experience Level: Intermediate
3:48
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.

This lesson, Part 1, is the basics.  Whether you are writing VBA for Excel, Access, Word, or another Microsoft Office application,  basic error handling is the same.

Video Steps

01. Set up the error handler


   At the top of the code for your procedure, the error handler is set up using     On Error GoTo Proc_Err

02. Exit Code


   After whatever your procedure does, a line label for the exit code (such as Proc_Exit: ) is used to signify what happens at the end of the procedure. This can be code to cleanup object variables, or simply code to gracefully exit.

03. Error Handling Code


   After the exit code, a line label for the error handling code (such as Proc_Err: ) is used to begin what happens if there is an error.
Receive 1:1 tech help
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

3
Comment
  • 2
3 Comments
 
LVL 24
This is a short video to introduce you to basic error handling code that can be used, not only in Excel, but in any VBA application.  While it is the first video in a 3-part series, it can be watched on its own.  Comfort with programming helps but is not necessary.

If you want to see how to apply this information to an Excel example, also watch:

Part 2. The next video in this 3-part series will cover the specific task that the code accomplishes, which is copying values to blank cells in a column of an Excel spreadsheet.  This step will show the manual process and the code to automate it.
http://www.experts-exchange.com/videos/1498/Excel-Error-Handling-Part-2-VBA-to-Copy-Values-Down-to-Blank-Cells-in-an-Excel-Column.html

Part 3. The last video in this series, part 3, breaks code that is working and shows how to use the error handler to fix errors and continue.
http://www.experts-exchange.com/videos/1518/Excel-Error-Handling-Part-3-Run-and-Fix-Bugs.html
0
 

Expert Comment

by:chris pike
For someone who is trying to wrap their brain around VB for the first time, this video is starting to shed light on the subject.
Well done video, very helpful.

Thanks so much.
I will definitely look out for more videos from crystal (strive4peace).
0
 
LVL 24
thank you, Chris and you're welcome  ~ if you have any questions about basic error handling, please post them here.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Join & Write a Comment

This is an article on how to answer questions, earn points and become an expert.
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Total Time: 17:40

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month