Microsoft Excel 2016 MACROS

Microsoft Excel 2016 MACROS


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.


1 Day

Target Audience

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.


1: 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

2: 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

3: 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)

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

Appendix A: Selected VBA Procedures
IF…THEN…ELSE (Conditional Control Structure)
SELECT CASE (Branching)
The DO…LOOP control structure
The FOR…NEXT control structure

Course Details

Course Ref:


Course Duration:

1 Day

Course Location:


Course Dates:

Please call for dates...

Course Price (Excl VAT):


Course Location:

Virtual Classroom

Course Dates:

27th Jun 2022 - 27th Jun 2022
25th Jul 2022 - 25th Jul 2022

Course Price (Excl VAT):

Please call for prices...

Book this course

Course Downloads

Send course details to a colleague


   To book or for further information, please telephone 0191 515 3355 or e-mail us at