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.

Table of contents

  • About
  • Getting started with VBA
  • Accessing the Visual Basic Editor in Microsoft O?ce
  • Debugging
  • First Module and Hello World
  • Comments
  • Apostrophe Comments
  • REM Comments
  • String Literals - Escaping, non-printable characters and line-continuations
  • Escaping the " character
  • Assigning long string literals
  • Using VBA string constants
  • VBA Option Keyword
  • Option Explicit
  • Option Base {0 | 1}
  • Option Compare {Binary | Text | Database}
  • Declaring Variables
  • Type Hints
  • Variables
  • Constants (Const)
  • Declaring Fixed-Length Strings
  • When to use a Static variable
  • Implicit And Explicit Declaration
  • Access Modi?ers
  • Declaring and assigning strings
  • Assignment to and from a byte array
  • Declare a string constant
  • Declare a variable-width string variable
  • Declare and assign a ?xed-width string
  • Declare and assign a string array
  • Assign speci?c characters within a string using Mid statement
  • Concatenating strings
  • Concatenate an array of strings using the Join function
  • Concatenate strings using the & operator
  • Frequently used string manipulation
  • String manipulation frequently used examples
  • Substrings
  • Use Left or Left$ to get the 3 left-most characters in a string
  • Use Right or Right$ to get the 3 right-most characters in a string
  • Use Mid or Mid$ to get speci?c characters from within a string
  • Use Trim to get a copy of the string without any leading or trailing spaces
  • Searching within strings for the presence of substrings
  • Use InStr to determine if a string contains a substring
  • Use InStrRev to ?nd the position of the last instance of a substring
  • Use InStr to ?nd the position of the ?rst instance of a substring
  • Comments
  • VBA Option Keyword
  • Declaring and assigning strings
  • Frequently used string manipulation
  • Searching within strings for the presence of substrings
  • Measuring the length of strings
  • Date Time Manipulation
  • Naming Conventions
  • Arrays
  • Collections
  • Sorting
  • Passing Arguments ByRef or ByVal
  • Working With Files and Directories Without Using FileSystemObject
  • Creating a procedure
  • Conditional Compilation
  • Creating a Custom Class
  • Recursion
  • Scripting.Dictionary object
  • Attributes
  • CreateObject vs. GetObject
  • API Calls
  • Macro security and signing of VBA-projects/-modules
  • Error Handling

It is a free VBA ebook created for beginners. The content is extracted from Stack Overflow pltaform, which is written by many VBA developers and contributors.

The content is released under Creative Commons BY-SA

Size2.25 MB
File typepdf
Downloads481
Created2019-04-30
Cover of VBA Tutorials for professionals
Preview PDF

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

  • Excel 2016 Shortcuts

    With this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free training document in pdf designated 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....

  • Download Publisher 2016 PDF tutorial

    Download Publisher 2016 PDF tutorial by techtutor under 10 pages intended to beginners....

  • Excel Data Analysis, 2nd Edition

    This book offers a comprehensive and readable introduction to modern business and data ana..., download free Excel Data tutorial in PDF (358 pages) created by Hector Guerrero ....

  • Advanced Microsoft Excel 2013

    Download free Microsoft Excel 2013 advanced Tutorial , course tutorial training, a PDF file in 87 pages for beginners....

  • Excel Data Analysis

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

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

  • Quick guide to Word 2010

    A course to learn how to use the Word 2010 version, PDF training course to download for free, Microsoft Office Word 2010, training support in 4 pages...

  • Introduction to VBA in Excel - PDF Tutorial

    This is a tutorial showing how to use the macro facility in Microsoft Office—Visual Basic for Applications—to simplify analytical tasks in Excel....