When you add VBA code in the editor, always make sure to place your VBA code on the object and using the correct action that you want to use to trigger that code. Other worksheet actions you can use to trigger your VBA code include when the worksheet changes, when it’s closed (deactivated), when the worksheet calculation is run, and more. When you’re in the VBA editor, you need to use the two dropdown boxes at the top of the editing window to choose which object you want to attach the code to, and when you want the code to run.įor example, in Excel, if you choose Worksheet and Activate, the code will run whenever the worksheet is opened.

The only difference are the objects you can reference and the actions you can take on those objects through the VBA code.īefore we dive into the different objects and actions you can take on them via VBA code, let’s first look at the most common VBA structure and syntax you can use when you write VBA code.

The structure and syntax of the VBA code is the same across all applications. So, don’t be surprised by the different menus. In Word, you can add VBA code to documents.

For example, in Excel, you can add VBA code to workbook or sheet objects. This is because the available objects where you can place VBA code depend on what objects there are in the application.

Microsoft visual basic for applications