Visual Basic for Applications video tutorials

Whatever you're doing in VBA, we've probably published an online training video for it! We've split the videos on creating and using user forms into a separate series.

Category Description Videos
Excel VBA - Basics This set of videos roughly follows the contents of our two-day introduction to VBA course. 22
VBA User Forms You can draw custom dialog boxes in VBA called user forms, and manipulate their controls using VBA (as this series of tutorials will teach you). 20
Excel VBA - pivot tables Videos on how to programmatically manipulate pivot tables, charts and PowerPivot within Excel. 8
Excel VBA - charts Using VBA to create and manipulate charts, including how to conditionally format them. 6
VBA - advanced Miscellaneous additional VBA topics which don't fit conveniently into any other category (including working with arrays, ByRef and ByVal arguments and much more). 11
VBA - working with files Using FileSystemObjects to manipulate files and folders, and saving data as PDF files. 4
VBA - linking applications Linking Excel, Word, PowerPoint, Outlook and other Microsoft Office applications programmatically. 3
VBA - working with Outlook Using Outlook with VBA, including how to create emails and loop through folders in Outlook. 13
Built-in VBA functions Videos on how to use some of the built-in VBA functions, and also videos on working with specific data types such as strings and dates. 9
VBA - working with data Getting VBA to work with recordsets of data from Access or SQL Server, or any other data source for that matter. 10
VBA - scraping websites Using VBA to scrape websites (that is, to download the HTML content and programmatically parse this to extract content). 8

Just click on any of the links above to see a complete listing for that category of VBA videos.

This page has 1 thread Add post
05 Jan 20 at 08:24

I would like to take time and appreciate Andrew for his brilliant work. I have downloaded all the "Excel VBA Introduction" Playlist from YouTube and it really helped me to learn and create interest in learning more. it's been 2 months since I started learning VBA; because of my job it is not possible to practice on a daily basis but I try to practice whenever i get time.

Moreover, your voice and teaching method force us to listen more and more. it gives me two benefiits: first, initially I couldn’t understand your accent because English is not my first language, and secondly, it helps to improve my English with learning VBA.

I wish I could attend your live lectures. Nevertheless, you are doing a really great job Andrew, sometimes just because of your learning method and skill Iwatch your video  The proficiency, skill along with in[depth knowledge that you transfer to world (and that free) I really appreciate and I really admire.

 

Your Sincere Student

Mithun

06 Jan 20 at 13:31

Hi Mithun, many thanks for your kind comments!  I'm happy to hear that you've found the videos useful for both VBA and English!