Video: How to design and code an Excel VBA application like a Pro
Van: Paul Kelly - Excel Macro Mastery
Duur: 42:26
Paul Kelly heeft een manier bedacht waarmee je heel gestructureerd de vba-code kunt opslaan in de verschillende modules. In deze video legt hij de structuur uit.
Paul 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.
