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

Course Outline

Excel 2013 Macros and VBA

Excel 2013 Macros and VBA

Course Contents

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 
Exercises

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 
Exercises  

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) 
Exercises

Introduction to Controls
Worksheet controls 
User forms
Assign Macros to the Ribbon or Quick Access Toolbar
Accessing Macros in Excel 
Exercises 

Price per delegate

£249

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 info@indiciatraining.com

Contact Us