You are currently viewing HOW TO USE MACROS IN EXCEL? WHAT IS MACRO AND  HOW TO CREATE IT?
how to use macros in excel

HOW TO USE MACROS IN EXCEL? WHAT IS MACRO AND HOW TO CREATE IT?

In this article I will teach you how to use macros in excel and how to write your first macros code in excel. But before writing a macro in excel you must know what is Macro. A macros is a short peace of programming which use to repeat a task. It save the time once a Macro has developed you don’t need to write again it.

To learn the Macro you don’t need to have basic programming language. A Macro writes in VBA Programming which is already installed in MS Office application. For its installation don’t need to have any heavy hardware and PC or laptop.

For writing the Macro in Excel environment you need to learn basic knowledge of VBA code, to make advance function in Macro.

Why Is Excel Macros Used in Excel?

As a human we are creatures of habit. There are many works we are doing on daily basic on every next day. It will be better if you routine work don not repeated and it will done on only single button click. So for it you need to write a short peace of code in Macro Excel. This short function will automatically done that task which you was repeated.  A Macro is recording of your routine work step in Excel that you can replay using a single button.

Example of Routine Work.

For example you are the Accountant of a Hotel. Some customer pay the bill through bank payment is called debit or credit card. The Hotel manage required to you download the bank statement reconcile it and make a business report format.

For it you will import the data in Excel format as you want. This work you will do daily and it will be boring for you in next some days. Macro will solve these kind of problem and it will be don automatically these task on daily basis.

VBA is the part of Visual Basic programming language that excel use to store your step and perform it as you want as routine work. For its you don’t need to become a good programmer, and required any technical skill about it. Just it will manage your office work with more efficient and quickly. Macro excel will generate the automatic source code in specific task given to it.

Enable Developer Mode In Excel

To write you first Macro in excel you need to enable the developer mode. By default it is not appear in the ribbon table in excel. Macro is one of the feature of developer.

Before run you macro you will need to enable running macros. If you want to run excel Macro you need to save it as Macro Enable Format .xlsm. When you save any macro in excel you must write the description of macro for which task you have created. It is easy to understand you when you apply it.

Step 01. open you Run command enter the excel and hit enter.

Step 02. Click on file menu then select option.

how to use macros in excel

Step 04. Click on customize Ribbon in the  left side.

Step 05. Check on the Developer in the right side .

how to use macros in excel

Developer Mode Enable In Ribbon

how to use macros in excel