To use VBA in Excel you need Developer Tab in the Ribbon. Developer tab will give you an access to activeX controls and buttons like check box, input box and toggle button. A developer tab is disabled by default. In this tutorial, you will learn how to enable a developer tab in Excel.
How to enable Developer tab in Excel
To enable the Developer Tab in Excel, you need to follow these steps:
Click File tab.
Go to Options at the botton of the menu.
Select Customize Ribbon.
Select Main Tabs. Tick Developer check box.
Now, you can see Developer tab at the Ribbon in Excel.
Congratulations! You’ve successfully enabled the Developer Tab in Excel.
Using the Developer Tab
With the Developer Tab now enabled, you can access a wide range of tools and features to enhance your Excel experience. Some of the functionalities you can explore include:
- Creating Macros
- Inserting Controls
- Customizing the Ribbon
- Accessing Visual Basic for Applications (VBA)