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
| Size | 2.25 MB |
|---|---|
| File type | |
| Downloads | 481 |
| Created | 2019-04-30 |
Others VBA tutorials
Others related eBooks about VBA Tutorials for professionals
-
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....
-
Microsoft Excel 2013 for beginner
Download free Microsoft Office Excel 2013 Tutorial course material, tutorial training, PDF file on 25 pages....
-
Microsoft Word 2016 free tutorial
Download free Microsoft Word 2016 course material and training (PDF file 214 pages)...
-
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 ...
-
Introduction to Microsoft Word 2013
This support shows you in detail all the features of this new version of the popular word Microsoft Word 2013; it is for anyone wishing to discover and deepen all its features....
-
Introduction to Microsoft Publisher
Download Introduction to Microsoft Publisher in PDF, free training document about how to create a perform basic tasks and creating business and greeting card....
-
Microsoft Excel 2016 Course for Beginners
Looking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf....
-
Introduction to Excel VBA Macro programming
Introduction to Excel VBA Macro programming, Learn Excel tools by utilizing them in various cases, Understand the logic and syntax behind Visual Basic programming, which interacts with the Excel interface...
-
Excel 2016 PivotTables and PivotCharts
Learn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download....
-
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....