Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. ' Declare public compilation constant in Declarations section. The following example runs debug code or production code, based on the value of the variable. You declare a conditional compiler constant in code with the #Const directive, and you denote blocks of code to be conditionally compiled with the #If.Then.#Else directive. Try to go through the macro using their data, one line at a time, until you discover where your code went wrong and then fix it.Use conditional compilation to run blocks of code selectively, for example, debugging statements comparing the speed of different approaches to the same programming task, or localizing an application for different languages. In those cases, the debugging process is the exact same as mentioned above-except you use their data as your test worksheet. In this way, you will make your macro much more useful.ĭon't be surprised, however, if you give your workbook to some friends and they discover bugs you never thought of. Try the macro out in all these ways and under all these conditions. Design, develop, test, debug and document applications according to the functional requirements. The Print string expression sends string expr as output to the Immediate window at Debug run time. (I particularly like to use the F8 key to step through the macro one line at a time.)Īs you are debugging macros, you need to make sure you think through every possible way the macro could be used and all the possible conditions that could exist at the time the macro is invoked. The Debug object has two methods, Print and Assert. As you step through the macro (using the commands available in the Debug menu of the VBA Editor), you can correct any errors you locate.

You do this by viewing both the windows for your macro and a test worksheet. Debug. All you need to do is step through the macro, one command at a time, and make sure it works as you think it should. VBA provides a Debug object with two properties, Print and Assert that you can use display a variables value and to control the program flow. The process of debugging a macro in VBA is the same as debugging in any other programming language. When you write a macro, you need to test it and correct any errors in the macro. In Excel, macros are written in a language called Visual Basic for Applications, or VBA.

Excel vba debugging