VBA API Tutorial
Thanks to the different lessons, you will learn the VBA (Excel macros) for free ...
If you think that creating macros is too complicated and is not within your reach, rest assured, this course is suitable for beginners in programming and starts from scratch.
Like the Excel course, the lessons are rich in examples and simplified as much as possible to facilitate the learning of the VBA.
It is recommended that you follow the lessons in the order given, as you will need the knowledge from previous lessons for each new lesson.
Table of contents
- Introduction
- Introduction to Excel VBA (Developer)
- API Commands for RIT
- RIT API Initialization
- Algorithmic Trading Example - Arbitrage
Macros
- Basic principles
- Programming methodology
- Automatic macros
The basics of programming
- Publisher VBE
- Variables, constants
- Conditional instructions
- Loops for next
- Loop loops
- While wend
- Links between macros
- Workshop: Realization of a first project
VBA Excel Object
- The Excel object model
- Objects and collections of objects
- Application Object
The forms
- Create a form
- customize a form
- Events of the form objects
- Running / closing a form
- Custom forms
- Validate programmatically with basic VBA commands
Create custom functions
- the creation of functions.
- The notion of arguments
- Create, save a custom function
- Use a custom function
Manage procedures properly
- Create a private procedure
- Call a procedure with or without arguments
- Make optional arguments
- Use ByRef and ByVal
The array variables
- Create a table
- Set up a multicolumn array
- Sub-procedure and table
- Create a dynamic table
Manage events
- Workbook and Sheet Event Overview
- Manage events on workbook
- Manage events on a sheet
The basics of object programming
- Define the notions of class and object
- Composed variables
- Module and class module
- Class Creation in Programming
- Define the notions of private and public
Create variables, methods, and class functions
- Discover class methods and variables
- Create object instances
- Parameter class method
- Discover class functions
| Size | 878.189 Kb |
|---|---|
| File type | |
| Downloads | 622 |
| Created | 2018-05-23 |
Others VBA tutorials
Others related eBooks about VBA API Tutorial
-
How to use formulas in Excel calculation
With this PDF tutorial you will learn how to use the Formulas in Excel to compile, claculate and manage data, free training document by OWL....
-
Microsoft Excel 2016 Course for Beginners
Looking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf....
-
Microsoft Word 2016 free tutorial
Download free Microsoft Word 2016 course material and training (PDF file 214 pages)...
-
Excel 2016 PivotTables and PivotCharts
Learn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download....
-
Microsoft Excel 2013 course
Download free Microsoft Office Excel 2013 file under 505 pages,step by step to learn Excel and build your skills , course tutorial training on pdf by Curtis D. Frye....
-
Microsoft Office 365
Download free course Microsoft Office 365, pdf file on 337 pages by Katherine Murray....
-
Excel 2016 Functions Tutorial
Download Excel 2016 Functions Tutorial, free PDF document intended to anyone wants to learn the basics of Excel functions....
-
Full list of Excel functions
Download the complete list.of Microsoft Excel functions, free training document in pdf....
-
Microsoft Excel 2013
Download free Microsoft Excel 2013 Tutorial , a PDF training file under 12 pages for beginners....
-
Microsoft Excel Tips & Tricks
These are some of my favorite tips and power features that’ll get you well on your way to ‘Excel Guru Status’ giving you not only the recognition you deserve, but also making your work more enjoyable....