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

свернуть