Excel VBA Expert Tutorial

Welcome to the Excel VBA Expert tutorial. This is the third video focusing on Excel VBA and the sixth video in our Excel tutorial series. Be sure you have completed the first five videos as this will ensure you have the necessary tools to be effective during these more advanced tutorials. You may also want to ensure you have a notebook and pen handy for taking notes and writing down specific steps to aid you as you progress through this tutorial. 

In the VBA Expert Tutorial you will be able to:

1.  Work with manipulating Code regarding sheets.
   1. Move, Copy, and Print sheets with code.
2. Combine all the VBA code into a real-world scenario.
3. Work with UDF's (User Defined Functions)

Please note you will need to download several Sample Files to complete this video tutorial. I have provided links to the files in the Support Documents section below!

 This third VBA Tutorial is roughly 1.25 hours in length and is broken into chapters:

CHAPTERS:

Worksheets Methods 0:03
DateSerial and Format 3:28
Sheet Template Generator 13:32
Move 20:21
PrintOut and PrintPreview 23:40
Practice (Part 1) 25:51
Practice (Part 2) 34:20
Practice (Part 3) 35:54
Practice (Part 4) 37:38
Practice (Part 5) 41:11
Practice (Part 6) 51:48
Custom Functions (Part 1) 54:18
Custom Functions (Part 2) 1:01:01
Custom Functions (Part 3) 1:04:32
Wrapping Up 1:14:07

Support Documents:

DateSerial and Format

Sheet Template Generator

Reordering Sheets

Printout, Print Preview

Move, Copy, and Print based on User Input

UDF's

Additional Support Documentation: (Optional)

Excel VBA - Handout