If you do not see this Developer tab in your Excel, follow the below steps to enable the Developer tab in Excel. This tab is disabled by default on excel thus, the user needs to enable it first from the options menu. VBA coding is available under the DEVELOPER tab in excel DEVELOPER Tab In Excel Enabling the developer tab in excel can help the user perform various functions for VBA, Macros and Add-ins like importing and exporting XML, designing forms, etc. Let us record the Macro to start with the VBA Macro coding VBA Macro Coding VBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task. The Macro code can eliminate repetitive, boring tasks and automate the process. Once we write the code in VBA, we can execute the same task at any time in the workbook.

Source: VBA Tutorial () What are the Macros in Excel?Ī Macro is nothing but a line of code to instruct Excel to do a specific task. You are free to use this image on your website, templates, etc., Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked

Step 3: Click on OK to Start the Recording.

Step 3:Check the box DEVELOPER to enable it.Step 1: Go to FILE -> Under FILE, go to OPTIONS.

Microsoft visual basic for applications