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
-
Quick guide to PowerPoint 2010
This pdf tutorial will help you understand PowerPoint 2010 features and create presentation for school or work. I will show you how to use each feature step by step so you you will learn PowerPoint 2010 easily and efficiently....
-
Microsoft Word 2013
Download courses Microsoft Word 2013 in PDF ,a free training document under 15 pages for beginners....
-
Basic Formulas in Excel
Download basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks....
-
Introduction to Microsoft Word 2013
This support shows you in detail all the features of this new version of the popular word Microsoft Word 2013; it is for anyone wishing to discover and deepen all its features....
-
Microsoft Excel 2007 : Essential Guide
The purpose of this course is to provide a basic guide for student who wants to be familar with the basics of Microsoft Excel 2007....
-
VBA Tutorials for professionals
Download free VBA tutorial course in PDF, training file in 46 chapters and 202 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
-
Excel Basics: Microsoft Office 2013
This course is intended to beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system....
-
Download Publisher 2016 PDF tutorial
Download Publisher 2016 PDF tutorial by techtutor under 10 pages intended to beginners....
-
Commonly Used Excel Functions
Here are some basic formulas that are easy to do and that can give some life to an Excel sheet!, download free PDF training document under 17 pages....
-
Beginning Microsoft® Excel®
This textbook was written for a community college introductory course in spreadsheets utilizing Microsoft Excel. While the figures shown utilize Excel 2016, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and...