Chapters

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

https://cdn.shopify.com/s/files/1/0298/0039/8988/files/VBANotesForProfessionals.pdf?857