Visual Basic for Applications (VBA) in Excel - Advanced Certificate for Petro Fedchak
Certificate ID:
581019
Authentication Code:
31f80
Certified Person Name:
Petro Fedchak
Trainer Name:
Marek Michno
Duration Days:
2
Duration Hours:
14
Course Name:
Visual Basic for Applications (VBA) in Excel - Advanced
Course Date:
22 March 2019 09:00 to 17:00
Venue:
Zabierzów k/Kraków
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