VBA Notes for Professionals book

Chapters

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