Home » Office » VBA Tutorials for professionals

VBA Tutorials for professionals

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

Pages :
File type : pdf
Downloads: 382
Submitted On: 2019-04-30
License:
Author(s):

Take advantage of this course called VBA Tutorials for professionals to improve your Office skills and better understand VBA.

This course is adapted to your level as well as all VBA pdf courses to better enrich your knowledge.

All you need to do is download the training document, open it and start learning VBA for free.

This tutorial has been prepared for the beginners to help them understand basic VBA Office. After completing this tutorial you will find yourself at a moderate level of expertise in VBA from where you can take yourself to next levels.

This tutorial is designed for VBA students who are completely unaware of VBA concepts but they have basic understanding on Office training.

Preview Download

Tutorials in the same categorie :