So it’s vital that you use them in your development. These are very important for catching errors before you run your code. VBA has built-in tools for finding errors. Then we will look at the Debug.Assert statement. Let’s have a look at your first line of defence when it comes to errors. Therefore finding bugs early and close to the cause is a priority. When a bug is found in delivered code many of the following steps are required If you average the time on each bug to 30 minutes then you are talking 8 to 25 hours spent on errors for every 1000 lines of code.ģ0 Minutes is an optimistic average. “I am indeed amazed when I consider how weak my mind is and how prone to error.” – Rene DescartesĪccording to Steve McConnell in ‘Code Complete: A Practical Handbook of Software Construction’: “there are about 15 – 50 errors per 1000 lines of delivered code”. Before we look at the VBA Assert statement and creating assertions lets have a quick look at a startling fact about errors. Assertions are available in almost all programming languages. The VBA Assert statement allows us to create assertions in our code. Once you see how useful it is you will want to keep using it. If you adopt this technique then I guarantee you will see results almost immediately. Reading about the VBA Assert statement is not enough – you have to actually try it out for yourself. It will save you considerable time creating applications and it will make your application practically bulletproof. I have used this technique thousands of times on countless projects. When used correctly, the VBA assert statement will vastly reduce the number of errors in your VBA code.

The VBA Assert statement is a very powerful statement that simply evaluates a condition to be true or false.īut don’t let the simplicity fool you. This post provides a complete guide to the VBA Assert statement(i.e. 12 Using Assertions With Collections and Objects.10 How to Turn VBA Debug.Assert On or Off.8 How to Use the VBA Debug.Assert Statement.

7 Using VBA Debug.Assert to create an Assertion.4 Why Use the VBA Debug.Assert Statement?.2 A Startling Fact About Errors in Code.

Debug excel file