VBA Notes for Professionals

by Stack Overflow Community

DescriptionTable of ContentsDetailsHashtagsReport an issue

Book Description

The Visual Basic .NET Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow.

This open book is licensed under a Creative Commons License (CC BY-SA). You can download VBA Notes for Professionals ebook for free in PDF format (2.3 MB).

Table of Contents

Chapter 1
Getting started with VBA
Chapter 2
Comments
Chapter 3
String Literals - Escaping, non-printable characters and line-continuations
Chapter 4
VBA Option Keyword
Chapter 5
Declaring Variables
Chapter 6
Declaring and assigning strings
Chapter 7
Concatenating strings
Chapter 8
Frequently used string manipulation
Chapter 9
Substrings
Chapter 10
Searching within strings for the presence of substrings
Chapter 11
Assigning strings with repeated characters
Chapter 12
Measuring the length of strings
Chapter 13
Converting other types to strings
Chapter 14
Date Time Manipulation
Chapter 15
Data Types and Limits
Chapter 16
Naming Conventions
Chapter 17
Data Structures
Chapter 18
Arrays
Chapter 19
Copying, returning and passing arrays
Chapter 20
Collections
Chapter 21
Operators
Chapter 22
Sorting
Chapter 23
Flow control structures
Chapter 24
Passing Arguments ByRef or ByVal
Chapter 25
Scripting.FileSystemObject
Chapter 26
Working With Files and Directories Without Using FileSystemObject
Chapter 27
Reading 2GB+ files in binary in VBA and File Hashes
Chapter 28
Creating a procedure
Chapter 29
Procedure Calls
Chapter 30
Conditional Compilation
Chapter 31
Object-Oriented VBA
Chapter 32
Creating a Custom Class
Chapter 33
Interfaces
Chapter 34
Recursion
Chapter 35
Events
Chapter 36
Scripting.Dictionary object
Chapter 37
Working with ADO
Chapter 38
Attributes
Chapter 39
User Forms
Chapter 40
CreateObject vs. GetObject
Chapter 41
Non-Latin Characters
Chapter 42
API Calls
Chapter 43
Automation or Using other applications Libraries
Chapter 44
Macro security and signing of VBA-projects/-modules
Chapter 45
VBA Run-Time Errors
Chapter 46
Error Handling

Book Details

Subject
Computer Science
Publisher
GoalKicker
Published
2018
Pages
202
Edition
1
Language
English
PDF Size
2.3 MB
License
CC BY-SA

Book Hashtags

Related Books

Excel VBA Notes for Professionals
The Excel VBA Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
.NET Framework Notes for Professionals
The .NET Framework Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
Algorithms Notes for Professionals
The Algorithms Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
Angular 2+ Notes for Professionals
The Angular 2+ Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
AngularJS Notes for Professionals
The AngularJS Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
C# Notes for Professionals
The C# Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....