The Developer tab will now appear on the Ribbon and from it you can open the Visual Basic Editor.

Under the list of Main Tabs, select Developer.

From within an Office application, such Word 2016 or Excel 2016: Never fear, you can add it to the Ribbon by enabling the Developer tab. Must-read Windows coverageĭefend your network with Microsoft outside-in security services And although VBA is installed by default, accessing the Visual Basic Editor (VBE), through which you’ll enter your VBA code, doesn’t automatically appear in the Ribbon. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.Visual Basic for Applications (VBA for short) is a handy way to automate Microsoft Office tasks and is a favorite of many Word and Excel power users.

Object library reference for Office (members, properties, methods).

The error messages section contains common causes and solutions for any issues you may be having. Provides a glossary of definitions to help you understand concepts presented in this documentation.ĭescribes how to customize the Visual Basic editor, and provides documentation for the object model that enables you to extend the environment.ĭescribes user interface elements of the Visual Basic Editor, such as menus and commands, dialog boxes, windows, and toolbars.

Provides documentation about Visual Basic the language: all its methods, properties, statements, functions, operators, and objects.

Provides information about UserForms and controls, and how to program with them by using Visual Basic.ĭescribes useful common procedures (for example, how to use the Object Browser or how to set Visual Basic Environment options). Provides information to help you understand Visual Basic programming. Use the table of contents in the navigation on the left to view the topics in the following sections: Interested in developing solutions that extend the Office experience across multiple platforms? Check out the new Office Add-ins model.

Download excel 2016 vba documentation