Excel VBA Macro

you will learn how to write a simple macro in a step-by-step manner.

Step 1 − First, enable ‘Developer’ menu in Excel 2010-2019. To do the same, Check below image img-01.

Step 1 − Click File → Options

Step 2 − Click ‘Customize the Ribbon’ tab and check ‘Developer’. Click ‘OK’. Check below image img-02.

Step 3 − The ‘Developer Tab’ will appears on ribbon in the menu bar. Click ‘Developer’ tab to access VBA Macro Controls. Ref img-03.

Step 4 − Click the ‘Visual Basic‘ button to open the VBA Editor to start the code or use Shortcut key press ‘Alt+F11‘. Ref img-04.

Step 5 − Start your code in code area. Ref. img-05