VBA 2010 Video Tutorials

Visual Basic for Applications (VBA) allows you to incorporate powerfull code into your standard Microsoft Office Documents. These tutorials will teach you the ins and outs of how to use VBA within excel from nifty tricks to fully fledged mutli-user systems.

All our tutorial samples are free however if you appreciate our work and would like to make a voluntary donation then please do.

Download the samples for this series for free!

• VBA 2010 – 001: Creating a Macro
• VBA 2010 – 002: Referencing Ranges
• VBA 2010 – 003: Referencing With Cells
• VBA 2010 – 004: Hiding Rows and Columns
• VBA 2010 – 005: Referencing Selections
• VBA 2010 – 006: Variables
• VBA 2010 – 007: Numerical Operations
• VBA 2010 – 008: Strings
• VBA 2010 – 009: String Methods
• VBA 2010 – 010: Dates and Time
• VBA 2010 – 011: Date and Time Methods
• VBA 2010 – 012: Booleans
• VBA 2010 – 013: IF Statements
• VBA 2010 – 014: IF ELSE Statements
• VBA 2010 – 015: Nested IF Statements
• VBA 2010 – 016: Select Case (Switch)
• VBA 2010 – 017: AND + OR
• VBA 2010 – 018: Arrays
• VBA 2010 – 019: 3D Arrays
• VBA 2010 – 020: FOR Loops
• VBA 2010 – 021: Looping Through Arrays
• VBA 2010 – 022: Looping Through Objects
• VBA 2010 – 023: Nested For Loops
• VBA 2010 – 024: Looping 3D Arrays
• VBA 2010 – 025: Do While Loops
• VBA 2010 – 026: Do Until Loop
• VBA 2010 – 027: Nesting While/Until
• VBA 2010 – 028: Speeding up Loops
• VBA 2010 – 029: Calling Functions
• VBA 2010 – 030: Variable Scope
• VBA 2010 – 031: Passing Variables
• VBA 2010 – 032: Passing Multiple Variables
• VBA 2010 – 033: Returning Values
• VBA 2010 – 034: Passing Variables ByRef
• VBA 2010 – 035: Selection Change
• VBA 2010 – 036: Double Click
• VBA 2010 – 037: Worksheet Change
• VBA 2010 – 038: Worksheet Activation
• VBA 2010 – 039: Worksheet Open
• VBA 2010 – 040: Worksheet Close
• VBA 2010 – 041: Before Save
• VBA 2010 – 042: Creating a Userform
• VBA 2010 – 043: Command Buttons
• VBA 2010 – 044: Text Box
• VBA 2010 – 045: Option Buttons
• VBA 2010 – 046: Check Box
• VBA 2010 – 047: List Boxes 1
• VBA 2010 – 048: List Boxes 2
• VBA 2010 – 049: Frames
• VBA 2010 – 050: Multipage
• VBA 2010 – 051: Calendars
• VBA 2010 – 052: Backgrounds
• VBA 2010 – 053: Events
• VBA 2010 – 054: Command Buttons
• VBA 2010 – 055: Text Box
• VBA 2010 – 056: Drop Down Box
• VBA 2010 – 057: Spin Buttons
• VBA 2010 – 058: Check Box
• VBA 2010 – 059: Option Button
• VBA 2010 – 060: List Box
• VBA 2010 – 061: Sending Emails
• VBA 2010 – 062: Emails with Attachments
• VBA 2010 – 063: Shell Command
• VBA 2010 – 064: SendKeys
• VBA 2010 – 065: Defining Properties
• VBA 2010 – 066: Get and Let
• VBA 2010 – 067: Functions and Subs
• VBA 2010 – 068: Initialize & Terminate
• VBA 2010 – 069: Error Handling
• VBA 2010 – 070: Global Variables
• VBA 2010 – 071: ADODB
• VBA 2010 – 072: Recordsets
• VBA 2010 – 073: SQL WHERE
• VBA 2010 – 074: Multiple Records
• VBA 2010 – 075: SQL INSERT
• VBA 2010 – 076: SQL DELETE
• VBA 2010 – 077: SQL UPDATE
• VBA 2010 – 078: SQL Sanitation
• VBA 2010 – 079: SQL AND
• VBA 2010 – 080: SQL OR
• VBA 2010 – 081: SQL Numeric Parameters
• VBA 2010 – 082: SQL Date Parameters
• VBA 2010 – 083: SQL BETWEEN
• VBA 2010 – 084: SQL ORDER BY
• VBA 2010 – 085: SQL TOP
• VBA 2010 – 086: SQL COUNT & SUM
• VBA 2010 – 087: SQL GROUP BY
• VBA 2010 – 088: SQL JOINS
• VBA 2010 – 089: SQL DISTINCT
• VBA 2010 – 090: SQL Insertion
• VBA 2010 – 091: SQL Parameters
• VBA 2010 – 092: SQL Multiple Parameters
• VBA 2010 – 093: ADODB Spreadsheet Connection
• VBA 2010 – 094: Create a New Workbook
• VBA 2010 – 095: Open a Workbook
• VBA 2010 – 096: FileSystemObjects
• VBA 2010 – 097: Open all files in a Folder
• VBA 2010 – 098: ADODB +FSO = Amazing
• VBA 2010 – 099: GetOpenFilename
• VBA 2010 – 100: Creating Formulas
• VBA 2010 – 101: Creating Add-Ins
• VBA 2010 – 102: Passwording a Project
• VBA 2010 – 103: Calling Add-In Functions
• VBA 2010 – 104: Referencing Add-In Sheets
• VBA 2010 – 105: Add-In Events
• VBA 2010 – 106: Custom Right Click Menu
• VBA 2010 – 107: Right Click Sub-Menu
• VBA 2010 – 108: Right Click Menu Add-In
• VBA 2010 – 109: Customising all Menus
• VBA 2010 – 110: Read Input From Text File
• VBA 2010 – 111: Adding Data to a Text File
• VBA 2010 – 112: Creating a text file
• VBA 2010 – 113: Creating a HTML file
• VBA 2010 – 114: Creating a SQL file

Recommended Reading

Both the below books by John Walkenbach are fantastic books and he is a brilliant author, I would recommend picking one of these books up even if just for a reference. I have read power programming cover to cover and it is easy to follow and is a must have for any serious VBA programmer.

If you have read any books and feel they are worth recommending then please post about them on our Forum.