VBA Notes for Professional
Hello Developers! Today I will share with you such awesome notes
if you follow and practice the notes properly. You will not have to face any
more problems with VBA, Inshallah. So let's
discuss VBA notes in detail.
List 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 of 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
|
Notes Details |
|
|
Notes
Name |
VBA
Notes for Professional |
|
Publisher |
GoalKicker |
|
Total
Chapter |
46 |
|
Total
Pages |
196 |
|
Category |
Free
Programming E-book |
[Preview ##eye##] [Download ##download##]
Disclaimer!
This is an unofficial free book created for educational purposes and is not
affiliated with official VBA groups or companies. All trademarks and registered
trademarks are registered trademarks are the property of their respective
owners.
