Jepretan layar:
Deskripsi
######## Learn VBA ######## This app contains tutorials and reports for the all who want to Learn VBA. They can learn easily from this application. Following Chapters included in this Application:
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 for 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