You can double click on Module1 it is where your code for the task we performed in previous steps (Step 3 and 4) are recorded. Inside the Modules folder, you can see Module1 as soon as you click on the plus sign.Navigate towards the Modules section under VBAProject and click on the plus button under it to see the list of active modules in VBA.In order to go to Visual Basic Editor, you can click on the Visual Basic option under the Code category in the Developer tab, or you can use Alt + F11 as a shortcut for the same.All these steps are converted into a VBA code. It means, every single step, selecting cell A1, inputting the text as “This is my first VBA code, and I am happy!”, clicking Enter to go to the next cell. The magic behind all this is, Excel has recorded my steps here and converted those into pieces of code so that this task can be automated. Click on the Stop Recording button to stop the recording.
Record Macro Works as Play button and Stop Recording work as Stop button. Under the Code section, you might have observed that the Record Macro button has changed to Stop Recording.These steps will be recorded in the backend of the macro. Try typing the sentence “This is my first VBA code, and I am very happy!” in cell A1 within the Excel sheet and press Enter key.See the screenshot below for your reference.Īs soon as you click OK, the system starts recording the macro and all the tasks you perform will be recorded and converted to Excel Program in the backend. Can you add the description, if any, for this macro you are creating? Once you are done with all this, you can click on the OK button placed at the right bottom of the window. As soon as you click on the Record Macro button, you’ll see a window popping up in that window, you must have to assign a name to the macro you can also assign a shortcut key for this macro to run.Navigate towards the Developer tab you just enabled and then click on the Record Macro button, categorized and can be seen under the Code section. Because the Developer tab is needed to record and run the macro, this option tab is not by default enabled, which is why we tried enabling it here first. This is the first step you need to follow before you start writing macros in Excel.
0 kommentar(er)
