Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the function of Macros in MS Excel ?

i have seen an option in developer tab of MS Excel i just want to know how it works

user-image
Question added by jhangeer bazmi , Computer Instructor and Operator , Imran Computer College Millat Chowk
Date Posted: 2017/03/06
Muneeb Hassan
by Muneeb Hassan , Executive Admin , PTML Ufone (Etisalat Group)

If you have to repeat same set of tasks on daily basis in excel for example fathering data or etc then its a tool which actually ease your work by understanding and recording the pattern of your activities.

First you have to feed the flow of your work then MS Execl will do it by itself

Hafeez ur rehman Rajput
by Hafeez ur rehman Rajput , RAD OFFICER , Pakistan Stock Exchange Limited

You can even add your own macros to the Excel function menu, so that they are available to you in the same way as Excel's built-in functions. A macro is a piece of computer code, that is written for Excel, using the Visual Basic for Applications (VBA) programming language.

Karen Ler Maramba
by Karen Ler Maramba , Admin Aide , Provincial Government of Pangasinan

 it a programming instructions stored, a code that can be used to eliminate the need tasks over and over again or its a looping tasks.

MD SAIFUL ISLAM
by MD SAIFUL ISLAM , Site Engineer , mominaz builders

Excel macros save you time and headaches by automating common, repetitive tasks.

Imtiaz Ahmad
by Imtiaz Ahmad , Database Operators , FISO Connect (On behalf of Etisalat)

It is used to save our time, while working on same repetitive simple tasks. These are written in VBA.

adding number formatting to new data and worksheet formats such as borders and shading

Ayesha Naz
by Ayesha Naz , Bahria University Medical and Dental College

recording and easing the nature of repeated type daily work 

Marcos are recorded in the Visual Basic for Applications programming language.

A micros function can be defined as the recording of a series of tasks.

It's the simplest form of automation – show a software program the steps you follow to get something done, and the software will follow along.

When used right, micros can save you hours by automating simple, repetitive tasks.

Murtaza Dalotwala Murtaza
by Murtaza Dalotwala Murtaza , Accountant General , Direct Trading LLC

Macro are action or set of actions recorded and used to make the repating task easier and faster.

It is a code written for excel for VBA language.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.