Tutorial by Examples

You can open the VB editor in any of the Microsoft Office applications by pressing Alt+F11 or going to the Developer tab and clicking on the "Visual Basic" button. If you don't see the Developer tab in the Ribbon, check if this is enabled. By default the Developer tab is disabled. To enab...

To start coding in the first place, you have to right click your VBA Project in the left list and add a new Module. Your first Hello-World Code could look like this: Sub HelloWorld() MsgBox "Hello, World!" End Sub To test it, hit the Play-Button in your Toolbar or simply hit the...

Debugging is a very powerful way to have a closer look and fix incorrectly working (or non working) code. Run code step by step First thing you need to do during debugging is to stop the code at specific locations and then run it line by line to see whether that happens what's expected. Breakp...