Excel, MS Office, Outlook, PowerPoint, Word VBA Cheat sheet (21 votes, average: 4.95 out of 5) Loading... July 15, 2015 AnalystCave Welcome to my end-to-end VBA Cheat Sheet. Be sure to bookmark this page as your VBA cheat sheet! VBA FUNCTIONS Date, File, String and more functions Date Functions File Functions String Functions Conversion Functions VBA BASICS Basic VBA syntax, loops, variables, arrays, classes and more Hello World! Recording Macros Debugging VBA Variables Conditions(If-Else, Select) Loops Objects Classes VBA Type Enumerations Arrays Dictionaries and other data structures Regular Expressions and the Like operator VBA Performance VBA Events VBA Error Handling MessageBox UserForms FileDialogs Searching strings Substrings Progress Bar Status Bar Sound Notifications WORKING WITH FILES Working with files (Excel, text, CSV, XML etc.). Learn how to read, write, edit, download files in VBA etc. Reading files Writing files Traversing directories XML FTP Download / Upload files Downloading files Versioning Excel files Merging CSV or TXT files EXCEL VBA Excel VBA – working with Worksheets, Workbooks, Cells, Ranges, formatting etc. Ranges & Cells Worksheets & Workbooks Formatting UsedRange, Last Row, Column, Cell WORD VBA WordVBA – navigating around Word documents, formatting etc. Navigating / Moving Text formatting Tables DATA ANALYSIS EXCEL TOOLS …because sometimes you just don’t need to resort to VBA Sort & Filter Remove Duplicates PivotTable What If Analysis Data Analysis Toolpak Solver MS Query (SQL) This VBA Cheat Sheet is updated on a regular basis with the best new posts on VBA. VBA TIME SAVER Tired of having to constantly Google common VBA code snippets? Get the VBA Time Saver. Consisting of at least 7 Code Modules it is probably the largest colletion of VBA Code Snippets on the Web! Find code to manage VBA Arrays, Files, Strings, Regular Expressions, Performance Enhancement, VBA Structures and even an animated Progress Bar, all with ready examples to save you time. DOWNLOAD THE VBA TIME SAVER Post navigation Previous PostWorking with XML files in VBA (VBA XML)Next PostNative VBA Multithreading? There is only 1 but… Simply the best place to learn VBA!