Visual Basic for Applications (VBA) in Excel - Advanced Training Course
Course
In City Of London
Description
-
Type
Course
-
Location
City of london
The course reveals the secrets of effective writing advanced applications in VBA application MsExcel.
After the course you can:
Write an advanced object-oriented application
Convert text files
Use of external data sources
Use external libraries
Facilities
Location
Start date
Start date
Reviews
Subjects
- Excel
- Object oriented training
- Visual Basic training
- Object-oriented training
- Property
- Writing
- Visual Basic
- Programming
- Oriented Programming
- MS Excel
Course programme
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)
- Application-level events
- Dynamic arrays
- Table arrays Variant
- Optimizing arrays and memory
- Multi-dimensional arrays
- 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 a collection
- Adding and removing items
- References to the components (using a key and an index)
- 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)
- Opening and closing text files
- Reading and writing text and binary data
- Processing of records in the CSV file
- Efficient processing of text files
- Create your own add-ons
- Create a toolbar for addition
- Installing your own add-ons and their protection
Visual Basic for Applications (VBA) in Excel - Advanced Training Course