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

Others VBA Tutorials

VBA Notes for Professionals

Introduction to VBA in Excel - PDF Tutorial

Learning access-vba PDF course

Introduction to Excel VBA Macro programming

Excel VBA tutorial for professionals

Others related eBooks about VBA API Tutorial

Microsoft PowerPoint 2013 step by step

This courses is designated to beginning-level and intermediate-level computer users. It teach you some skills that can be used to make a beutiful presentation....

Guide Excel 2010

A little guide in PDF,it will clarify the new basics features added to Microsoft Excel 2010 ,free training tutorial under 24 pages....

Microsoft Excel 2016 Tutorial

Download a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages...

How to Create Professional Reports and Documents in Microsoft Word

This is a free Microsoft Word PDF tutorial in 10 chapters and 39 pages. This course aims to give students the basics of Microsoft Word concepts. ...

PowerPoint 2013 course

Download Microsoft powerpoint 2013 courses for student, free training document in PDF designated for brginners....

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

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

How to Use Microsoft® Excel®

How to Use Microsoft® Excel® The Careers in Practice Series is an textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel...

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

The Beginner’s Guide to Microsoft Excel

This is a free Excel PDF tutorial in 11 chapters and 23 pages. This course aims to give students the basics of Microsoft Excel tips and trics. ...