Find Error Line Number in VBA With Erl

In this post you are going to find out a way of handling errors in your code with the Erl function.

Erl displays the last label before the error

Another alternative error handling solution is using labels at each point in long procedure.

Here we get a random error:

Here is the code behind the form:

Since the form “frmNothing” doesn’t exist, we have an error at line 40.

Again: Erl displays the last label before the error which may be beneficial to you.

Let me know if you have any questions.


 

Free! Subscribe To Our YouTube Channel!

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather
Tags: , , ,




 

Call Erik Now