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 ckeck box, input box and toggle button.
The thing is that a developer tab is disabled by default. In this tutorial you will learn how to enable developer tab in Excel.
How to enable Developer tab in Excel?
The Developer Tab in Excel is used to access advanced features, such as creating macros, customizing the ribbon, and inserting controls like group boxes, option buttons, and check boxes. To enable the Developer Tab in Excel, you need to follow these steps:
To enable a developer tab go to the Ribbon menu on top of your screen. Click File tab.
Go to Options at the botton of the menu.
In the Excel Options window, select "Customize Ribbon".
From customize the ribbon select Main Tabs. Tick Developer check box. Click "OK" to close the Excel Options window.
Now you can see Developer tab at the Ribbon in Excel.
If you need to use the controls and features provided by the Developer Tab, you can enable it as described above. This will allow you to access the controls and features you need to customize your worksheets and create more advanced Excel solutions.