Once you know what macros you'd like to set up and have the Developer tab ready, here's what to do in Excel on Windows or macOS: Click the Developer tab and find the Code group.

To make accessing forms even easier, you can add the Forms command to your Quick Access Toolbar (QAT). This allows you to quickly open the form tool without navigating through the Developer tab.

In Microsoft Excel, Word orPowerPoint, the Developer tab is an optional tab that allows users to access form controls and other programming type controls such as Macros, Mapping, Add-ins ...

The Developer tab on the ribbon in Excel is selected. The Excel ribbon right-click menu is opened, and Customize The Ribbon is selected.

The Draw tab is not on Excel's ribbon by default. Learn how to enable, add and use the Draw tab and the various drawing tools in Excel.

VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.