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: | 108 |
| Created: | 2022-02-03 |
| License: | CC BY-SA |
| Author(s): | Stack Overflow Community |
Others VBA Tutorials
Introduction to VBA in Excel - PDF Tutorial
Introduction to Excel VBA Macro programming
Others related eBooks about VBA Notes for Professionals
Introduction to Spring MVCThis pdf tutorial is a step-by-step guide on how to develop a web application from scratch using the Spring Framework.Free training course material under 68 pages by Thomas Risberg, Rick Evans and Portia Tung....
JavaScript Notes for ProfessionalsDownload free course JavaScript Notes for Professionals, pdf file on 489 pages by Stack Overflow Community....
An Introduction to Programming in GoLearning Go language, free PDF tutorial in 168 pages. Go is an ideal language to learn as your first programming language....
Learn BlackBerry 10 App DevelopmentLearn how to leverage the BlackBerry 10 Cascades framework to create rich native applicati..., download free BlackBerry 10 tutorial in PDF (356 pages) created by Anwar Ludin ....
C Programming Notes for ProfessionalsDownload free course C Programming Notes for Professionals, pdf file on 341 pages by Stack Overflow Community....
The Coder's ApprenticeThe Coder's Apprentice is a course book, written by Pieter Spronck, that is aimed at teach..., download free Coding tutorial in PDF (398 pages) created by Pieter Spronck ....
Introduction to programming with Fortran 95Introduction to programming with Fortran 95. This tutorial aim to provide an introduction to programming with Fortran 95. Fortran is particularly suitable for science and engineering....
Hacking Secret Ciphers with PythonDownload free course Hacking Secret Ciphers with Python, pdf file on 442 pages by Al Sweigart....
Invent Your Own Computer Games with PythonInvent Your Own Computer Games with Python teaches you how to program in the Python langua..., download free Game Development tutorial in PDF (367 pages) created by ....
Introduction to Microsoft SharePoint 2016Download a free document of SharePoint 2016, a course in pdf on 64 pages for beginners....