Microsoft Excel VBA Programming (Level 4) 2007 2010 2013 2016 & 365
Training
In Sunderland
Description
-
Type
Training
-
Level
Advanced
-
Location
Sunderland
-
Duration
2 Days
-
Start date
Different dates available
Become fully proficient with Microsoft VBA Programming.
Individuals will be able to make use of the most powerful features of Microsoft Excel available through programming VBA code. Some of topics covered include macros, writing/editing code, variables, objects, properties and methods, control structures and debugging tools.
Important information
Documents
- Course content
Facilities
Location
Start date
Start date
About this course
The course is mainly aimed at individuals who have a good knowledge of Microsoft Excel including commands, functions and simple macros.
Experience of Microsoft Excel including commands, functions and basic macros is required for this course.
Certificate of participation can be obtained if required.
On receiving your request we will contact you to explain course content, including course dates and payment options.
Reviews
Subjects
- Microsoft Excel
- Programming
- Microsoft excel training
- MS Excel
- VBA (Microsoft Access / Office)
- Macros
- Excel Objects
- Excel Functions
- Debugging
- Excel Variables
Teachers and trainers (2)
Chris Edmondson
IT Trainer
Paul Robson
IT Trainer
Course programme
VBA Programming in Excel
The topics covered are as follows:
1 Introduction to Macros
· What is a Macro?
· Recording a Macro
· Running a Macro
2 Editing Macros
· The Visual Basic Editor
· The Project Explorer
· The Code Window
· Procedures
· Comments
· Printing a Module
3 The Range Object
· What is the Range Object
· The Cells Property
· The Range Property
· Range Contents
4 Workbooks and Sheets
· Activating a Workbook
· Activating a Worksheet
· This Workbook
5 Objects, Properties and Methods
· Controlling objects with Properties
· Performing Actions with Methods
· Performing Multiple Actions on an Object
6 Variables and Constants Control Structures
· Conditional Control Structures
· Looping Control Structures
· Non-Structured Statements
· Sub Procedures
7 Controls, Dialog Boxes and Forms
· Dialog Boxes
· Custom Forms
· Worksheet Forms
· Setting Properties of a Control
· Adding Controls
· Control and Dialog box Events
8 Storing Information
· The Registry
· Settings Files
9 Using Toolbars
· Toolbars and Menus
· Attaching Toolbars to Workbooks
· Customising Toolbars
10 Debugging and Error Trapping
· Types of Error
· Break Mode
· Instant Watch
· Stepping Through Code
· Error Handling
11 Function Procedures
· Function Procedures
· User Defined Functions
· Function Wizard
· Excel Functions
12 Add-In Applications
· What is an Add-in?
· Creating an Add-In
· Converting an Add-In to a Workbook
Microsoft Excel VBA Programming (Level 4) 2007 2010 2013 2016 & 365