This procedure creates a macro that is embedded in an event property of an object. In the Save As dialog box, type a name for the macro, and then click OK.Ĭontinue with the section Add actions to a macro. On the Create tab, in the Macros & Code group, click Macro. By calling the macro from other macros, you can avoid duplicating the same code in multiple places. Standalone macros are useful when you want to reuse the macro in many places of the application. This procedure creates a standalone macro object that will appear under Macros in the Navigation Pane. Here's a video that walks you through the main areas of the Macro Builder. Macro reuse The Action Catalog displays other macros you have created, letting you copy them into the one you’re working on.Įasier sharing Copy a macro, then paste it as XML into an email, newsgroup post, blog, or code sample web site. Program flow Create more readable macros with comment lines and groups of actions.Ĭonditional statements Allow for more complex logic execution with support for nested If/Else/Else If. Keyboard shortcuts Use key combinations for faster, easier macro writing. IntelliSense When typing expressions, IntelliSense suggests possible values and lets you select the correct one. Here are some of the main feature highlights of the Macro Builder.Īction Catalog Macro actions are organized by type and searchable. Depending on the context you are working in, some macro actions may not be available for use. Macro objects are visible in the Navigation Pane, under Macros embedded macros are not.Įach macro is made up of one or more macro actions. Embedded macros become part of the object or control in which they are embedded. Macros can be contained in macro objects (sometimes called standalone macros), or they can be embedded into the event properties of forms, reports, or controls. In this articleĬontrol program flow with If, Else If, and ElseĮxpand and collapse macro actions or blocks Note: This article doesn’t apply to Access web apps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |