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

Course Outline

Excel 2016 Macros and VBA

This is a 1 day, instructor-led course.

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 VB code and assign macros to screen items.

Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users’ work) in the application using macros.

Delegates should have a good grounding in Excel (any version) and be familiar with absolute Vs relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage. However, those wishing to learn or practice VBA itself should seek another course.

Excel 2016 Macros and VBA

This is a 1 day, instructor-led course.

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 VB code and assign macros to screen items.

Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users’ work) in the application using macros.

Delegates should have a good grounding in Excel (any version) and be familiar with absolute Vs relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage. However, those wishing to learn or practice VBA itself should seek another course.

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