Learn Excel VBA From Beginner Level With This 5-Hour Excel VBA Project

Why bother learning Excel VBA these days? Because its impact, as ever, is considerable for professionals like you who use Excel every day. Excel VBA can save huge amounts of time and effort, freeing you up to work on things you like working on, rather than boring, repetitive admin tasks. So many times in my career, I’ve seen VBA automate 10-minute tasks to complete them in 10 seconds or less – and people love it!

💻DOWNLOAD FILES LINK

The aim of this video is to provide a ‘real-world’ simulated Excel VBA project to support your VBA learning and help you apply the programming language to your work. Though the scenario is clearly fictional (Luna the dog doesn’t actually use Excel,) it’s based on situations I’ve seen time and again in organizational life.

By the end of the video, you will have built a degree of confidence with Excel VBA and should be in a position to start automating your own manual processes using Excel VBA.

All the resources are provided for free: a briefing file that specifies the requirements and gives the feel of a real-world ‘client’ project, a master file to house the Excel VBA and a source data file that we need to manipulate.

💻DOWNLOAD FILES LINK

So whether you’re a VBA beginner sitting down for a long coding session with me, or plan to come back to this video from time-to-time as an ongoing reference for your VBA learning, I look forward to helping you progress with Excel VBA!

Don’t forget to let me know how you’re getting on in the YouTube comments.

FOLLOW-UP VIDEOS AND LINKS
📺Excel VBA Absolute Beginner Video: Get Set Up For Excel VBA
📺Another Excel VBA Real-World Simulated Task
📺30 For 30: Learn Excel VBA In 30 30-Minute Videos From Absolute Beginner
📺Our Members’ Monday Excel (VBA) Learning Community

TIMESTAMPS
00:00:00 Task Introduction
00:05:27 Get To Know The VBA Editor And Create A Module
00:08:19 How To Use Option Explicit And Write The First Macro
00:12:46 How To Declare A String Variable
00:14:17 How To Use Excel VBA To Refer To Another Excel File
00:20:17 How To ‘Step Through’ VBA Code To Test It
00:25:14 How To Write A Macro To Copy A Worksheet In A File
00:26:24 How To Use The Macro Recorder To Generate VBA Code
00:35:34 How To Use VBA Code To Delete Worksheets In Excel
00:36:20 How To Create A For-Each Loop In Excel VBA
00:40:00 How To Use A Message Box To Test VBA Code
00:43:00 How To Write A Conditional Statement In Excel VBA
00:46:38 How To Switch Off Alerts With Excel VBA
00:54:45 How To Use VBA To Create Multiple Worksheets In A File
01:01:45 How To Change A Worksheet Name With Excel VBA
01:08:00 How To Change A Cell Value With Excel VBA
01:01:10 How To Use Offset To Reference An Adjacent Cell With Excel VBA
01:16:30 How To Create A Button To Trigger An Excel VBA Macro
01:18:35 How To Call One Macro From Another With Excel VBA
01:20:20 How To Create A User Confirmation Message Box With Excel VBA
01:28:00 How To Use Excel VBA To Loop Through Open Workbooks
01:33:00 How To Use A Boolean Variable In Excel VBA
01:38:00 How To Create A Module-Level Variable In Excel VBA
01:52:40 How To Use A With-End With Statement In Excel VBA
01:55:40 How To Fix A ‘Subscript Out Of Range’ Error In Excel VBA
02:00:55 How To Use A Breakpoint To Test VBA Code
02:04:35 How To Create A For-Next Loop In Excel VBA
02:12:25 How To Loop Through Cells In A Range With Excel VBA
02:20:45 How To Break An Endless Loop In Excel VBA
02:36:42 How To Test Multiple Conditions With IF In Excel VBA
02:42:59 Combine Loops, Conditional Statements, Offset and Variables In Excel VBA
03:05:50 How To Transfer Data Between Files With Excel VBA – Conceptual Explanation
03:07:50 How To Write VBA Code To Transfer Data With Excel VBA
03:13:33 How To Use The .Cells Referencing Technique In Excel VBA
03:29:20 How To Combine Offset With An Integer Variable In Excel VBA
03:51:42 How To Use Excel VBA To Save A Report As A PDF
03:53:33 How To Use The Macro Recorder To Generate PDF Creation VBA Code
04:05:00 How To Control PDF File Save Location With Excel VBA
04:26:15 How To Use The Watch Window To Debug VBA Code
04:31:54 How To Use Excel VBA To Send Email Through Outlook

[TigerSpreadsheetSolutions]

📺Watch More: EXCEL VBA ABSOLUTE BEGINNER SERIES

[tez]

The best VBA instructor on the net! Thank you

[henrikijonkoping]

Great Chris, I came to think of the series 30 for 30. It was a magical series for us that nothing could

[bobviously]

I really enjoy your videos Chris. I didn't like like the "Lists" or "Engine" sheets so much at first, but today, I found the "Very Hidden" property, so that the typical user can't unhide it. Given that, it's a programmer friendly and helpful approach!

[keithdangerfield]

Wow Chris, that was a marathon!
I think a beginner might struggle with it, but that was, as usual, an amazing Master Class!
It will be at the top of my "Recommended List".
Email to follow 😊

[excelconcepts]

Hello Cris ! I use R Programming, Python Programming for my statistical Analysis. But after listening to your videos and importance of VBA, i started using this for EDA projects. The basic reason is :- "The language that resides inside the Excel can automate it better." This is the reason provided by you and i experienced it.

[gillianmcnosehair]

Awesome. Thanks for this. Can't wait to get stuck into the project and develop further skills💪

[myarnie]

Hi Chris this is brilliant, at the 1:13.0 stage im getting eg Greyhound-Greyhound instead of Greyhound-Away i have the code exactly as yours Any clues as to where my error could be Thanks

[myarnie]

Hi Chris is there a way of including a Team twice in the Generator "Team Name"? One for Home and again for the Away match.
This doesnt occur often but does occur, even more so if one includes all matches in their Data eg FA Cup, CL as well as League games
Thanks

[stellalukita]

Hi Chris, I can't see the briefing file on the download link, perhaps I missed it somewhere? Thank you