VBA Book

What is VBA ?

Visual Basic for Applications (VBA) is an implementation of Microsoft’s event-driven programming language Visual Basic6, that was stopped in 2008, and its affiliated integrated development environment (IDE).

Although Visual Basic is no longer supported or updated by Microsoft, the VBA programming language was upgraded in 2010 with the introduction of Visual Basic for Applications 7 in Microsoft Office software.

Chapters

  • Chapter 1 :- Introducation of VBA
  • Chapter 2 :- Comments in VBA
  • Chapter 3 :- Option Keyword in VBA
  • Chapter 4 :- Declaring Variables in VBA
  • Chapter 5 :- Declaring and assigning strings in VBA
  • Chapter 6 :- Concatenating strings in VBA
  • Chapter 7 :- Frequently used string manipulation in VBA
  • Chapter 8 :- Substrings in VBA
  • Chapter 9 :- Searching within strings for the presence of substrings in VBA
  • Chapter 10 :- Assigning strings with repeated characters in VBA
  • Chapter 11 :- Measuring the length of strings in VBA
  • Chapter 12 :- Date Time Manipulation in VBA
  • Chapter 13 :- Naming Conventions in VBA
  • Chapter 14 :- Data Structures in VBA
  • Chapter 15 :- Arrays in VBA
  • Chapter 16 :- Collections in VBA
  • Chapter 17 :- Operators in VBA
  • Chapter 18 :- Sorting in VBA
  • Chapter 19 :- Flow control structures in VBA
  • Chapter 20 :- Passing Arguments ByRef or ByVal in VBA
  • Chapter 21 :- Scripting.FileSystemObject in VBA
  • Chapter 22 :- Creating a procedure in VBA
  • Chapter 23 :- Procedure Calls in VBA
  • Chapter 24 :- Conditional Compilation in VBA
  • Chapter 25 :- VBA Object-Oriented
  • Chapter 26 :- Creating a Custom Class in VBA
  • Chapter 27 :- Interfaces in VBA
  • Chapter 28 :- Recursion in VBA
  • Chapter 29 :- Scripting.Dictionary object in VBA
  • Chapter 28 :- Working with ADO in VBA
  • Chapter 29 :- Attributes in VBA
  • Chapter 30 :- User Forms in VBA
  • Chapter 31 :- CreateObject vs. GetObject in VBA
  • Chapter 32 :- Non-Latin Characters in VBA
  • Chapter 33 :- API Calls in VBA
  • Chapter 34 :- Automation or Using other applications Libraries in VBA
  • Chapter 35 :- Macro security and signing of VBA-projects/-modules in VBA
  • Chapter 36 :- Run-Time Errors in VBA
  • Chapter 37 :- Error Handling in VBA
  • Chapter 38 :- Many more VBA chapters cover in this book

Get your book just click on download button