There are several different ways to open up the VBA Editor that we have covered in this post. 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. When in the form designer you can click the VBA Editor Button under Tools to bring up the IDE. ![]() Using the ribbon, select the Create tab and on the far right you will see the Macros & Code group select Module. See all shortcuts Download 200+ Excel Shortcuts Get over 200 Excel shortcuts for Windows and Macin one handy PDF. There are a couple of different ways to open the editor. Blog Open VBA Editor Windows shortcut AltF11 Mac shortcut FnF11 This shortcut opens the Visual Basic Editor. 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). The above image is the VBA Editor with three areas highlighted the Project Explorer, Code Window and Immediate Window. ![]() In this blog post, we will show you how to open the VBA editor.
0 Comments
Leave a Reply. |