Easy VBA Macro (No Code Required)

Easy VBA Macro (No Code Required)

For Beginners...

 

 

In previous few articles we have discussed about how to create Macros in Excel VBA and applied some coding. In this article we'll make VBA more easy.

It is very interesting and surprising to know that you can create your own Macro without writing a single code and can Automate your day to day work by following few easy steps. As Excel is very user friendly tool so it gives two ways to create Macro. One is the Traditional way where you can write script in VBA and another is Smart way where you can create Macro by recording steps.

By recoding Macros you can automate your day to day repeated and time consuming work which you perform in excel and for this there is no requirement to be an excel expert.

Here are the steps:

• Go to Developer menu

• Click on Record Macro button as mentioned below

• Now Name your Macro and give a short cut key (optional) which trigger your Macro and select the Location where you want to store the Macro (Default Location: This Workbook)

• If you select New Workbook then a new Workbook get opens and all the recording will save there.
• Click OK
• Perform the task which you want to record or Automate
• Click on Stop Recording

• Now your Macro has been Recorded/Created
• You can execute your Macro by pressing Short key given to Macro

• Now you can also view the coding behind the macro. To review the coding press Alt+ F11

Tip: You can Start and Stop recording Macro by clicking record Macro icon below Sheet Tabs

Note: Recording Macro Coding will not be found in any module as recording did not create module.


We will talk more about excel & VBA in the next article.

You can share your feedback and post your excel queries in this blog.