Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Course Outline

Excel 2016 Macros and VBA

Excel 2016 Macros and VBA

Course Contents

Introduction and the Macro Recorder
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 

Price per delegate


Scheduled Classes

Indicia Training, Glasgow:

Please complete the contact form below or call 0141 221 5676 for further course information and available dates.
Alternatively you can email us at

Contact Us

Leave this field blank