Course description
Excel: VBA Introduction
The course is designed for existing; experienced users who need to use Microsoft Excel VBA to automate their spreadsheets.
Upcoming start dates
Suitability - Who should attend?
This interactive; hands-on course has been designed for people who wish to learn the essentials of Microsoft Excel VBA programming language; and how to setup and use the main concepts and methods of VBA programming; and understand the relevant techniques
Prerequisites
Delegates should have a good knowledge and understanding of Microsoft Excel to a high level. Familiarity with the content of the Level 2 course would be a minimum requirement.
Training Course Content
Recording Macros
- Recording a Simple Macro
- Running a Recorded Macro
- Relative Recording
- Running a Relative Recording, Viewing the Module
- Modifying a Recorded Macro
- Recorder Workshop
- Creating a Recorded Application
- Examining The Data
User-Defined Functions
- Creating a User Defined Function
- Using a User Defined Function
- Creating another Function
- Passing Multiple Arguments
- Modifying a Function
- Creating a Function Library
Using the VBA Editor
- Opening & Closing The Editor
- Working With The Project Explorer
- Working With The Properties Window
- Using The Work Area
- Working With a Code Module
- Running Procedures From The Editor
- Setting Break Points In The Editor
- Stepping Through a Procedure
Understanding VBA
- Using the Immediate Window
- Working With Object Collections
- Setting Property Values
- Working With Worksheets
- Using the Object Browser
- Programming With the Object Browser
Procedures
- Creating a Command Procedure
- Making Sense of IntelliSense
- Using the Edit Toolbar
- Commenting Statements
- Indenting Text
- Bookmarking In Procedures
Using Excel Objects
- The Excel Object Model
- Splitting the Screen
- Using Workbook Objects
- Using Worksheet Objects
- Using Range Objects
- Using Objects in a Procedure
Using Variables
- Creating & Using Variables
- Implicit & Explicit Declarations
- The Scope Of Variables
- Procedure Level Scoping
- Module Level Scoping
- Public Scoping Of Variables
- Passing Variables By Reference
- Passing Variables By Value
- Avoiding Variant Data Types
- Using Arrays
Programming Techniques
- Programming Conventions
- Communicating With The User
- Prompting For User Input, Using The Input Method
- Using IF To Make Decisions, Testing For Multiple Conditions
- Looping a Fixed Number Of Times
- Looping a Specified Number Of Times
- Looping An Unknown Number Of Times
Creating Custom Forms
- Creating a Custom Form
- Changing The Form Properties
- Adding Text Boxes To The Form
- Moving Controls
- Adding Label Controls To The Form
- Changing Text Box Control Properties
- Changing Label Control Properties
- Adding a Combo Box
- Adding Option Buttons
- Adding Command Buttons
- Running a Form
Programming Custom Forms
- Initialising the Form
- Closing The Form
- Updating The List
- Creating Error Checking Procedures
- Running a Form From a Procedure
Custom Menus
- Creating a New Menu
- Creating a Cascade Menu
- Adding Menu Commands
- Assigning Macros To Menu Commands
- Removing a Menu
- Automatic Startup
- Consolidating Worksheets by Category or by Position
Sharing Workbooks
- Programming Automatic Events
- Running Automatic Procedures
- Automatically Starting The Workbook
Why choose SquareOne Training
25 years' experience of delivering quality IT Training Services
All trainers Certified Microsoft Office Trainer (MOS) or higher
Public and in-house training throughout the UK
Reviews
Average rating 5
All of the content was amazing
Expenses
For information on pricing for this open/scheduled course, please send an enquiry here
This course can also be delivered in-house and tailored to meet the particular requirements of your organisation.
Request info
SquareOne Training
With 30 years of experience in IT training, personal skills, and consultancy, SquareOne specialise in crafting and delivering exceptional industry leading training courses. Our extensive range of courses are tailored to cater to a diverse range of learning preferences and...
Case Studies
SquareOne Deliver IT Rollout Projects to a World Leading Gas and Oil Company
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
Excel Templates For Mexichem
At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.
Creating a Macro in Excel was great