Main menu

Pages

VBA Notes for Professionals book

 

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

Images

Variabes in VBA
Variables

DateTime Manipulation VBA
DateTime Manipulation

Download Now


reactions

Comments