Visual Basic for Applications (VBA in abbreviation) is a handy approach to automate Microsoft Office tasks and its a favorite of a lot of Word and Excel power users. Even though VBA is installed automagically, accessing the Visual Basic Editor (VBE), with which you'll enter your VBA code, doesn't automatically appear in the Ribbon.

Never fear, you can add it toward the Ribbon by enabling the Developer tab. From inside an Office application, such Word 2016 or Excel 2016:

Click File
Click Options
Click Customize Ribbon
Under the list of Main Tabs, select Developer
Click OK

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

If opening the Developer tab and clicking submit is a little a lot of work, additionally you can open the editor when using the keyboard shortcut Alt+F11, which fits whether the Developer tab is enabled or perhaps.