1 / 9

ME 142 Engineering Computation I

ME 142 Engineering Computation I. Macros. Key Concepts. Macro Overview Recording a Macro Running a Macro Editing a Macro. Macro Overview. A macro is a short program or set of recorded keystrokes Stored as VBA program Great for repetitive tasks Can be edited

abdul-haney
Télécharger la présentation

ME 142 Engineering Computation I

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ME 142Engineering Computation I Macros

  2. Key Concepts Macro Overview Recording a Macro Running a Macro Editing a Macro

  3. Macro Overview • A macro is a short program or set of recorded keystrokes • Stored as VBA program • Great for repetitive tasks • Can be edited • Great way to learn new VBA functions

  4. Recording a Macro • Recording of a macros can be launched from the View and Developer tabs or the lower left of the spreadsheet window

  5. Recording a Macro • Select Use Relative References button, if desired, prior to recording macro

  6. Recording a Macro • Prior to recording the macro, a dialog box is displayed • Note in particular: • Shortcut key • Storage location

  7. Ending a Macro Recording • Use the Stop Recording button on from the View or Developer tabs or the lower left of the spreadsheet window

  8. Running a Macro • Click on Macro from the View or Developer ribbons to list available macros • May also use previously assigned shortcut key combination to launch macro

  9. Editing a Macro • Edit a Macro as you would any VBA program • Alternately may launch editor by clicking on Macro in the View or Developer ribbons and selecting Edit

More Related