Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages

Course Outline

Excel Macros and VBA

Excel 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

Remote Access:

01 Mar 2024
29 Apr 2024

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

Leave this field blank