VBA (Visual Basic for Applications) in Excel course
– VBA@Work
Learn and master Visual Basic for Excel programming
The Challenge
How do you level up your control and automation of work tasks on Excel?
Visual Basic for Applications is a development environment of scripts (mini-programs) that allow you to define functions and methods with which you can control objects in MS Office applications.
This work environment allows you to automate actions that you would normally use the mouse or keyboard for, and in addition, you can dynamically create actions that are not available to users through the visual interface. If you are an advanced user of Microsoft Excel and have an openness to programming, this course will help you create mini-applications that will significantly increase the productivity of your users, while providing them with security.
Training Summary
VBA@Work is a course aimed at advanced Excel users who want to learn the key skills in programming in Visual Basic for Applications – with specific use for MS Office Excel.
Who should attend?
The following profiles will benefit from this course:
- Programmers
- Advanced MS Excel users
- Database specialists (Access, SQL, etc)
Note: For participation in this course it is important to have a minimal understanding of programming concepts and advanced use of MS Excel.
What do participants get?
By the end of this course, you will:
- Familiarize yourself with how to use Visual Basic for Applications
- Understand the basics of OOP (Object Oriented Programming)
- Learn to define your own functions
- Control the running of macros
- Learn how to debug code
- Learn to automate actions/operations in MS Excel
- Learn to use decision structures
- Learn how to use relative references in automation
- Increase productivity at work
Trainers
Cristian Stirbescu
Microsoft Certified Senior Trainer
Microsoft certified trainer since 2012. Frequently recognized as one of the best trainers in the industry. Interacts openly with learners through a fresh approach to course delivery.
VBA course agenda
Topics are delivered in an interactive, practice-centered format, covering the following areas:
Overview of Macro Usage
User-defined functions, Overview of user-defined functions, Creating a user-defined function, Using a user-defined function, Creating other functions, Using multiple parameters for functions, Modifying a function, Creating a function library
Working with the VBA Editor
Overview, Using the editor, Project explorer, Working with the Property Window, Using the work area, Working with code modules, Running procedures in the editor, Setting break point in the editor, Running a procedure step by step
Understanding VBA language
Introduction to VBA, Using Immediate Window, Object collections, Setting values for properties, Working with (Work)sheets, Using Object Browser
Introduction to procedures
Creating a procedure, Using Autocomplete, Using Edit Toolbar, Using Comments, Indentation, Using bookmarking in procedures
Using variables
Creating and using variables, Implicit and explicit declarations, Validity of variables, Scope of procedures, Scope of scope of modules, Public scope of variables, Variable referencing, Variable referencing by value, Avoiding variant data types (default), Using Arrays
Using Excel objects
Screen layout, Workbook objects, Worksheet objects, Range objects, Using objects in a procedure
Programming techniques
Programming conventions, Communicating with the user, Requesting information from the user, Using the Input method, Using IF for decision making, Testing for multiple conditions, Looping
Creating custom forms
Introduction to creating custom forms, Changing form properties, Adding text box to a form, Moving controls, Adding label control to a form, Changing text box control properties, Changing label control properties, Adding combo box, Adding option button, Adding command button, Running a form
Programming custom forms
Initializing a form, Closing a form, Updating a list, Creating error checking procedures, Running a form from a procedure
Automatic startup
Scheduling automatic events, Running automatic procedures, Automatic file startup
Registration
We offer price options for individual participation and for groups.
For groups of more than 10 participants variable discount is included for courses dedicated to your organization.
PrIce per participant
1-9 participants
For individual participation or groups of up to 9 participants
price per group
10-15 participants
Fixed price for groups of 10 to 15 participants
*All prices are VAT Exclusive
Customized training
Dedicated sessions
Dedicated sessions are available for a minimum of 8 participants.
Looking for something different?
Is this option not quite what you’re seeking? Give us a sign and we’ll help with a personalised solution.
Registration
Do you have a group of at least 8 colleagues interested in this topic and would you like to organize a dedicated session for your company?
Let’s get in touch! Send us an email at training@axioma-solutions.co.uk
Are you looking for something different?
If this isn’t exactly what you’re after, let us know, and we’ll develop a tailored solution for you. Access our contact information here.
Copyright information
MS Excel, Visual Basic for Applications and VBA are registered trademarks of Microsoft Corporation