Excel VBA Cheat sheet

Written by on in Excel, MS Office, Outlook, PowerPoint, Word

Welcome to my end-to-end VBA Cheat Sheet. Be sure to bookmark this page as your Excel VBA cheat sheet!. Visual Basic for Applications makes automation possible in Excel and other Office applications. The below Excel VBA Cheatsheet is your one stop shop for a variety of useful VBA automations. If you are new to VBA start with my Excel VBA Tutorial.

VBA BASICS

Basic VBA syntax, loops, variables, arrays, classes and more

Record Macro VBA
Recording Macros
Debug VBA
Debugging VBA
Variables VBA
Variables
Conditions VBA
Conditions
(If-Else, Select)
Do For Loops VBA
For Loops
Do While Loops VBA
Do While / Do Until loops
Class VBA
Classes
VBA Types
VBA Type
Enum VBA
Enumerations
Arrays VBA
Arrays
Data Structures VBA
Dictionaries and other data structures
Regex VBA
Regular Expressions, the Like operator
Performance VBA
VBA Performance
Events VBA
VBA Events
Errors VBA
VBA Error Handling
Msgbox VBA
MessageBox
Userform VBA
UserForms
MsgBox VBA
FileDialogs
Find VBA
Searching strings
VBA Substring
Substrings
VBA Progress Bar
Progress Bar
VBA Status Bar
Status Bar
VBA Sound Notifications
Sound Notifications

VBA FUNCTIONS

Date, File, String and more functions

Array Funtions VBA
Array Functions
Date Funtions VBA
Date Functions
File Functions VBA
File Functions
String functions vba
String Functions
Converstion functions vba
Conversion Functions

File vba WORKING WITH FILES

Working with files (Excel, text, CSV, XML etc.). Learn how to read, write, edit, download files in VBA etc.

Read file vba
Reading files
Write file vba
Writing files
Excel VBA Cheat Sheet - traverse folder vba
Traversing directories
excel vba
XML
Download file vba
FTP Download / Upload files
Download file vba
Downloading files
Version file vba
Versioning Excel files
Merge CSV or TXT files
Merging CSV or TXT files
VBA Delete files
VBA Delete Files

VBA Excel EXCEL VBA

Excel VBA – working with Worksheets, Workbooks, Cells, Ranges, formatting etc.

Range vba
Ranges & Cells
Worksheet vba
Worksheets & Workbooks
Formatting excel vba
Formatting
VBA last row
UsedRange, Last Row, Column, Cell

DATA ANALYSIS EXCEL TOOLS

…because sometimes you just don’t need to resort to VBA

Sort and Filter
Sort & Filter
Remove duplicates in excel
Remove Duplicates
PivotTable
PivotTable
What If Analysis
What If Analysis
Data Analysis Tools
Data Analysis Toolpak
Excel VBA Cheat Sheet - Solver
Solver
Excel VBA Cheat Sheet - MS Query
MS Query (SQL)

WORD VBA

Word VBA – navigating around Word documents, formatting etc.

Navigating Word
Navigating / Moving
Word Text Formatting
Text formatting
Word Tables
Tables
Word Tables
VBA Find and Replace

POWERPOINT VBA
Word Tables
Copy from Excel to PowerPoint

This VBA Cheat Sheet is updated on a regular basis with the best new posts on VBA.

VBA TIME SAVER

Excel VBA Cheat Sheet - VBA Time Saver KitTired 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

Related posts: