Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Excel Object Model
- The protection sheet from VBA
- Object Workbook, Workbooks collection
- Worksheet Object, Collection Worksheets
- Validation sheets
- Practical methods of the Range object
- Copy, paste, paste special
- Property CurrentRegion
- Find, replace
- Sorting ranges
- Charts (Object Chart)
Events
- Application-level events
Boards
- Dynamic arrays
- Table arrays Variant
- Optimizing arrays and memory
- Multi-dimensional arrays
Object-Oriented Programming
- Classes and Objects
- Creating classes
- Creating and Destroying Objects
- Create methods
- Create property
- Validation data using property
- The default properties and methods
- Error handling in the class module
Create and manage collections
- Create a collection
- Adding and removing items
- References to the components (using a key and an index)
Advanced structures and functions VBA
- Passing parameters by value and reference (ByRef and ByVal)
- Procedures with a variable number of parameters
- Optional Parameters and Defaults
- Procedures of unknown number of parameters (ParamArray)
- Enumeration, convenient parameter passing
- Type the user (User-defined Type)
- Service Null, Nothing, empty string "", Empty, 0
- Type conversion (Conversion)
File Operations
- Opening and closing text files
- Reading and writing text and binary data
- Processing of records in the CSV file
- Efficient processing of text files
Use VBA functions in other applications
Extras
- Create your own add-ons
- Create a toolbar for addition
- Installing your own add-ons and their protection
Using external libraries
Connecting to external databases (ODBC, OLEDB)
14 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
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.
Łukasz Rózga - 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.
