VBA Notes for Professionals
Table of contents
- Getting started with VBA
- Comments
- String Literals - Escaping, non-printable characters and line-continuations
- VBA Option Keyword
- Declaring Variables
- Declaring and assigning strings
- Concatenating strings
- Frequently used string manipulation
- Substrings
- Searching within strings for the presence of substrings
- Assigning strings with repeated characters
- Measuring the length of strings
- Converting other types to strings
- Date Time Manipulation
- Data Types and Limits
- Naming Conventions
- Data Structures
- Arrays
- Copying, returning and passing arrays
- Collections
- Operators
- Sorting
- Flow control structures
- Passing Arguments ByRef or ByVal
- Scripting.FileSystemObject
- Working With Files and Directories Without Using FileSystemObject
- Reading 2GB+ files in binary in VBA and File Hashes
- Creating a procedure
- Procedure Calls
- Conditional Compilation
- Object-Oriented VBA
- Creating a Custom Class
- Interfaces
- Recursion
- Events
- Scripting.Dictionary object
- Working with ADO
- Attributes
- User Forms
- CreateObject vs. GetObject
- Non-Latin Characters
- API Calls
- Automation or Using other applications Libraries
- Macro security and signing of VBA-projects/-modules
- VBA Run-Time Errors
- Error Handling
| Pages | 202 |
|---|---|
| Size | 2.3 MB |
| File type | |
| Downloads | 201 |
| Created | 2022-02-03 |
| License | CC BY-SA |
| Author(s) | Stack Overflow Community |
Others VBA tutorials
Others related eBooks about VBA Notes for Professionals
-
Download Django tutorial in PDF
Download free Django tutorial course in PDF, training file in 53 chapters and 228 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
-
COBOL in 21 days
This tutorial present an easy way to learn COBOL in a few days,free training courses in PDF for beginners and intermediate level users....
-
Arduino Development Cookbook
The single-chip computer board Arduino is small in size but vast in scope, capable of bein..., download free Arduino tutorial in PDF (246 pages) created by Cornel Amariei ....
-
Deep Learning and the Game of Go
The ancient strategy game of Go is an incredible case study for AI. In 2016, a deep learning-based system shocked the Go world by defeating a world champion. Shortly after that, the upgraded AlphaGo Zero crushed the original bot by using deep reinforcement learning to master the game. Now, you can l...
-
Programming in ADA, PDF Tutorial
Learn Programming in ADA, a complet PDF Tutorial by Wikibooks contributors....
-
Java-Based Real-Time Programming
Download free course Java-Based Real-Time Programming, pdf file on 128 pages by Klas Nilsson....
-
Creating Games in C++ : A Step-by-Step Guide
Creating Games in C++ : A Step-by-Step Guide,this PDF tutorial teaches You How to Build A Real Game, a complete training course under 600 pages by David Conger and Ron Little....
-
Python Multithreading free PDF
Download free course Python Multithreading free PDF, pdf file on 6 pages by tutorialkart.com....
-
Introduction to Eclipse
With this PDF tutorial you will learn how to creat a java program using Eclipse ,a free training document for download under 4 pages....
-
Full Speed Python
Download free course Full Speed Python, pdf file on 39 pages by João Ventura....