Microsoft Excel 365 / 2019 / 2016 Macros
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VBA code and assign macros to screen items.
Prerequisites
- Microsoft Excel 2016 Level 3 or equivalent experience
Outline
- Introduction and the Macro Recorder
- Introduction
- Demonstration
- Recording a macro
- Recording a macro with absolute references
- The personal macro workbook
- Assigning shortcut keys
- Deleting macros
- Excel’s New File Format
- Recording a macro with relative references
- Creating and Editing Macros With VBA Macro Functions
- Macro storage concepts
- The VBA program (the VB editor)
- The program components
- Storing and handling macros (modules)
- Introduction to editing code
- Copying and pasting procedures
- Linking procedures together
- Create and use a user-defined function
- Auto-executable macros
- Objects and Dialog Boxes
- Introduction to objects
- The object browser
- Using the object browser and searching it
- Built-in dialog boxes
- User defined dialog boxes (message boxes and input boxes)
- Introduction to Controls
- Worksheet controls
- User forms
- Assign Macros to the Ribbon or Quick Access Toolbar
- Accessing Macros in Excel