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


  • 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 : pdf
Downloads: 596
Created: 2018-05-23
VBA API Tutorial

Others VBA Tutorials

Learning access-vba PDF course

VBA Tutorials for professionals

VBA Notes for Professionals

Introduction to Excel VBA Macro programming

Introduction to VBA in Excel - PDF Tutorial

Others related eBooks about VBA API Tutorial

Office 365: Migrating and Managing Your Business in the Cloud

Written for the IT professional and business owner, this book provides the business and technical insight necessary to migrate your business to the cloud using Microsoft Office 365. This is a practical look at cloud migration and the use of different technologies to support that migration. Numerous ...

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 2103 Step by Step

This PDF tutorial provides invaluable handson experience for who want to learn about new features in Word 2013 .It's a free and complet training document under 576 pages for download....

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...

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....

Microsoft Excel 2013 Tutorial

Download free Microsoft Office Excel 2013 Tutorial course material, tutorial training, PDF file on 25 pages intended to beginners....

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....

Excel Data Analysis

Download free course Excel Data Analysis, pdf file on 358 pages by Hector Guerrero....

Microsoft PowerPoint 2007

This PDF tutorial is aimed at beginner who wants to creat their own PowerPoint presentation ,easy course with illustrative images,free training lesson under 14 pages by Dawn Rauscher....

Excel 2016 Math with Dates and Times

With this tutorial, you will learn a lot of shortcuts and custom formatting options about Dates and Times in Excel 2016. Training documents courses on 17 pages for beginners....