Now let’s save this workbook using the “Excel macro Enabled” option. This particular property is used for the selected value within the control here. To use the data in cell 1 as the sheet name, we will include the range along with the value property. Over here, the object that we will be using is the name of the sheet. Over here, we have used the “if” condition and fetched the value entered in Cell A1.Īfter that, we will input the Active Sheet keyword which will basically return an object that will represent the sheet which is currently active. For doing this, we will use a range for the target address. We will write a basic code that will fetch the data from a cell and use that as the name for the sheet that would be currently activated. The Sheet change event handler basically activates the code once any change is made on the sheet. Once opened, select the “General” option from the Object drop down list and then create an event handler by selecting the “Sheet Change” option. This is because over here, we want the code to be applied on the whole workbook, instead of any particular sheet. Simply double click on “This Workbook” module from the Project Explorer menu on the left corner of the window. Over here, you have the project explorer on the upper left side of the screen, the properties window, which will show the properties of the selected item and the window where the code is displayed. Over here, we will click on the “Visual Basic” button to open up the VBA editor.

Simply move to the tab and you can work with a number of options related to adding and editing macros. Once you enable that option, you will notice the Developer tab will be appearing in the menu no top. For that, we will open up the Excel options window and over here enable the “Show Developer Tab” option. For example, changing the formatting of a whole document in a specific way, etc.įollow this step by step tutorial where we will guide you on how to write Microsoft excel macros using Visual Basic.įirst of all we have to enable the Developers Tab in order to access Microsoft Excel macros. By writing VBA excel macro, you can automate a number of tasks which otherwise might take a lot of your time. You can easily get started with writing the visual basic code by enabling the feature in Microsoft Excel.

How to write vba in excel 2016