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
Size878.189 Kb
File typepdf
Downloads622
Created2018-05-23
Cover of VBA API Tutorial

Download

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