Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Test Macro By Using Single Step Mode. This is to test if the macro inserts the text in cell A2 or not. By pressing F8 you can single step through your code.
You can use various combinations of the F8 key to step through code and also use the yellow arrow and right mouse button to change the next executable statement. I want to see line by line execution of the full macro code. In lesson 4 you have created your first macro and tested it using the Run button.
This macro defn appears in a h file.
This macro defn appears in a h file. If the macro is a new or edited macro you will be prompted to save the macro before you can run it. Then select the Debug command in the VBA window and select Step Into. You can do this by either pressing the F8 key or selecting Step Into under the Debug menu.