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. 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.
Never fear, you can add it to the Ribbon by enabling the Developer tab. From within 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 now appear on the Ribbon and from it you can open the Visual Basic Editor.
If opening the Developer tab and clicking a button is a little too much work, you can also open the editor with the keyboard shortcut Alt+F11, which works whether the Developer tab is enabled or not.
SEE: Windows spotlight: 30 tips and tricks for power users (Tech Pro Research)
- Eight tips for working more efficiently in the Visual Basic Editor (TechRepublic)
- Three ways to find duplicates in Excel (TechRepublic)
- Using Excel's Find and Mid to extract a substring when you don't know the start point (TechRepublic)
- Excel errors: How Microsoft's spreadsheet may be hazardous to your health (ZDNet)
- Save time by using Excel's Left, Right, and Mid string functions (TechRepublic)
Bill Detwiler has nothing to disclose. He doesn't hold investments in the technology companies he covers.
Bill Detwiler is Managing Editor of TechRepublic and Tech Pro Research and the host of Cracking Open, CNET and TechRepublic's popular online show. Prior to joining TechRepublic in 2000, Bill was an IT manager, database administrator, and desktop support specialist in the social research and energy industries. He has bachelor's and master's degrees from the University of Louisville, where he has also lectured on computer crime and crime prevention.