Verminder de fouten in VBA

Video: Reduce VBA Errors by 90%

Van: Paul Kelly -  Excel Macro Mastery

Duur: 16:58

Er zijn 3 soorten fouten die in VBA gemaakt kunnen worden waardoor de macro stopt. In deze video worden ze uitgelegd en hoe ze voorkomen kunnen worden.
Paul Kelly legt ze in deze video uit en er kan een voorbeeldbestand gedownload worden.

In this video I'm going to show you a little-known method for reducing errors in your code by 90%. This method that I'm referring to is the Debug.Assert statement. You may have come across the Debug.Assert statment but you probably don't know how powerful it is when you use it correctly. In this video I'm going show how, when used correctly, Debug.Assert can help you identify and remove errors within seconds of them occurring. You can give you code to the user safe in the knowledge that it isn't full of errors.

00:00 - Introduction 00:57 - 3 Error Types 01:07 - Syntax Errors 02:16 - Compile Errors 03:33 - Runtime Errors 04:53 - Runtime Errors - Logical 08:22 - Debug Assert Application Example 10:27 - Debug.Assert Guidelines 12:15 - Turn off Debug.Assert 14:54 - Summary of Debug.Assert 16:51 - Download the source code

Functies: -