How to work efficiently with MS Excel Macros

You might be good with Excel and would know in and out about the application, but when it comes to Macros in Excel you might find yourself a novice. Macro in Excel is a study all together. It is so different from the normal tasks you do on Excel but once you get a hold on them your work could not become much easier. Just think o0f a task which you do by opening several option windows and by clicking multiple times on various buttons. What if this whole task gets completed in just one mouse click? Yes this is true, if you record a Macro for the same and execute it using a custom button than you can accomplish the same. Excel Macro is not just about recording the set of events but if you are good with programming then you can write your functions and can do the entire calculation without even using a single function in Excel sheet. I have done it and am sure you can also do the same, but for this you should be good in Visual Basic which runs as the backend of this kind of programmed macro and does all the procedural calculations. In this post I will discuss about the ways to record Macros and ways to invoke them. Macro Programming is a study all together and should get a book for yourself if you want to master it.

Recording Macro

Step1: click on the View Ribbon if on Office 2007 or later otherwise click on Tools menu in older versions

Step2: click on the Macro option/button

Step3: click on Record Macro

Step4: give your Macro a name so that it can be identified if you have multiple of them.

Step5: invoking Macro by set of key combinations is a good approach so you can also assign a shortcut key for your Macro in the same window.

Step6: click on OK and this will start the Recording of your Macro. Any task or activity which you will perform now will get saved. For example if you click on Bold and then on the Italics button then the next time when you will run this Macro it will automatically change the text of the Macro to BOLD and Italics in one go.

Step7: Once you are done with the series of steps which you intended to record click on the Macro button again and now you will find “Stop Recording” option available there. Click on it to stop the recording.

Invoking the Macro

Step1: You can run the Macro by the pressing the key combination that you had selected while recording the Macro.

Step2: Another method is to go to the Macro menu again and click on View Macros. This will list you all the recorded Macros by their Names and you can double click on the one which you want to run.

Step3: Another easiest way for most commonly used Macros would be to create command buttons for them. This can be done by Right clicking the toolbar and selecting Customize. In Customize Toolbar window you can select Macro and then select the Macro by its name.

Leave a Reply

Your email address will not be published. Required fields are marked *