Opening The VBA Editor

In this blog post, we will show you how to open the VBA editor.

The above image is the VBA Editor with three areas highlighted; the Project Explorer, Code Window and Immediate Window.  This is what is known as an Integrated Development Environment (which means everything you need to write programs and code are all in this one window).

There are a couple of different ways to open the editor.

The VBA Editor through the Ribbon

Using the ribbon, select the Create tab and on the far right you will see the Macros & Code group; select Module.  This will open the VBA editor.

The VBA Editor through the Form Designer

When in the form designer you can click the VBA Editor Button under Tools to bring up the IDE.

The VBA Editor through the Form Designer Properties Window

When in a Form or Report in Design view, if you open the property window (F4) and click the Events tab, any of the ellipses (…) will open the VBA editor.

There are several different ways to open up the VBA Editor that we have covered in this post.

Related Posts