Course Outline
Excel Object Model
- Implementing sheet protection via VBA
- Managing the Workbook and Workbooks collections
- Working with the Worksheet Object and Worksheets collection
- Applying sheet validation rules
- Utilizing practical methods of the Range object
- Executing copy, paste, and paste special operations
- Accessing the CurrentRegion property
- Implementing find and replace functions
- Sorting data ranges
- Working with Charts (Chart Object)
Events
- Handling application-level events
Arrays
- Managing dynamic arrays
- Working with Variant table arrays
- Optimizing array performance and memory usage
- Utilizing multi-dimensional arrays
Object-Oriented Programming
- Understanding Classes and Objects
- Defining custom classes
- Instantiating and disposing of Objects
- Implementing methods
- Defining properties
- Validating data through properties
- Working with default properties and methods
- Implementing error handling in class modules
Creating and Managing Collections
- Initializing a collection
- Adding and removing collection items
- Referencing components via keys and indices
Advanced VBA Structures and Functions
- Passing parameters by value and by reference (ByVal and ByRef)
- Creating procedures with a variable number of parameters
- Using optional parameters and default values
- Implementing procedures with an unspecified number of parameters (ParamArray)
- Utilizing Enumeration for efficient parameter passing
- Defining User-defined Types
- Handling Null, Nothing, empty strings "", Empty, and 0
- Performing data type conversions
File Operations
- Opening and closing text files
- Reading and writing text and binary data
- Processing records within CSV files
- Optimizing text file processing efficiency
Integrating VBA Functions with Other Applications
Additional Topics
- Developing custom add-ins
- Creating toolbars for extensions
- Installing and protecting custom add-ins
Utilizing External Libraries
Connecting to External Databases (ODBC, OLEDB)
Testimonials (7)
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
Course - Visual Basic for Applications (VBA) in Excel - Advanced
I really enjoy the training. Huge and practical! knowledge of the trainer combined with his skill to conduct the training made the training time very efficient. The trainer recognized the level of participant's experience in VBA and provided exercises relevant to that experience which made the training very useful.
Barbara Peek - UBS Business Solutions Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel - Advanced
I was benefit from the trainer knowledge, explanation and tips.
Kornel Tymcio - UBS Business Solutions Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel - Advanced
I liked the trainer, nice guy with great attitude.
Lukasz Kanior - UBS Business Solutions Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel - Advanced
I generally enjoyed the knowledge and sense of humor.
Lukasz Rozga - UBS Business Solutions Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel - Advanced
I mostly was benefit from the fitted training to people needs.
Robert Solek - UBS Business Solutions Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel - Advanced
The whole topic is interesting - everything was OK.
