PowerPoint Presentation

Getting Starting With Microsoft Excel Macros.

What is Macro?. If you perform a task repeatedly you cam take advantage of a macro to automate the task. A macro is a series of functions written in a programming language that is grouped in a single command to perform the requested task automatically. Excel macros are used to save time and reduce the possibility of human error by automating repetitive processes. Macros use programming but you don’t need to be a programmer or have programming knowledge to use them ( though it certainly does help)..

Why Macros use?. Macros are used to save time and reduce the possibility of human error by automating repetitive processes. Other reasons for using macros include: •Standardization •Improving efficiency •Expanding excels’s capabilities •Streaming procedures.

Macro Examples. The application of Automation in the design process is virtually unlimited. Some real world examples of excel automation at work: Export to word , PPT, email, etc. Reset a spreadsheet template to blank Allow users who has little experience with excel to do complicated tasks. Automatically create folders. Combine multiple workbooks into one . And so on and so on . The possibilities are nearly limitless.

VBA. VBA stands for Visual Basic for Applications and is a simple programming language that is available through excel Visual Basic Editor(VBE), which is available from the DEVELOPER tab on the ribbon. When you record a macro, excel generates VBA code. If you want to record a macro and run it , there is no need to learn excel VBA . However, if you want to modify a macro , then you can do it only by modifying the VBA code in the excel VBA editor..

Macro Code In VBA. You can record and run micros from Excel even if you do not know Excel VBA . However, if you have to modify a recorded macro or create a macro by writing VBA code, you should learn Excel VBA . You can refer to the Excel VBA tutorial in this tutorial library for this . However, you should know to view the macro code. You can learn how to access VBA editor in Excel and about the different parts of the VBA. Editor . You can learn how to view macro code in VBA excel editor and you can understand the macro in the code –understanding macro code..

How to create Macros. Macros within Excel are created by two primary methods: Using the macro recorder. Writing custom code with the macro editor. To view macros in a workbook: Go to view tab at top>Macros Keyboard shortcut: Alt+F8..

Macro Recorder. One method for creating macros is by recording your mouse actions by: Going to view > Macros>Record Macro Enter the name to hn click OK Excel is now recording your actions until you click the stop button in the left hand corner. Do &Don’t Don’t : Record more than is absolutely necessary. Don’t: Use the UNDO button when recording a macro. Do : Check each macro after its recorded..

Excel Macros Creation. You can create a macro with Excel commands by recording the key strokes and mouse clicks, giving the macro a name and specifying how to store the macros . A macro thus recorded can be run with an excel command..

Macro Recorder. The Macro Recorder, a very useful tool included in Excel VBA, records every task you perform with Excel. All you have to do is record a specific task once. Next, you can execute the task over and over with the click of a button. The Macro Recorder is also a great help when you don't know how to program a specific task in Excel VBA. Simply open the Visual Basic Editor after recording the task to see how it can be programmed..

Record a Macro. On the developer tab, click Record Macro..

Enter a name. Select This Workbook from the drop-down list. As a result, the macro will only be available in the current workbook..

Note: if you store your macro in Personal Macro Workbook, the macro will be available to all your workbooks (Excel files). This is possible because Excel stores your macro in a hidden workbook that opens automatically when Excel starts. If you store your macro in New Workbook, the macro will only be available in an automatically new opened workbook. Click OK..

Right mouse click on the active cell (selected cell). Be sure not to select any other cell! Next, click Format Cells..

Select percentage. Click OK..

Finally click Stop Recording. Congraulations. You’ve just recorded a macro with the Macro Recorder!.

Run a recorded Macro. Now we’ll test the macro to see if it can change the number format to Percentage. 1. Enter some numbers between 0 and 1. 2. Select the numbers..

3.On the Developer tab , Click OK..

4.Click Run..

5.Result:.

See the macro. To take a look at the macro, open the Visual Basic Editor..

Summary. Macros simplify our work lives by automating most of the routine works that we do. Macros Excel are powered by Visual Basic for Applications..