Excel VBA For Beginners: 30 Real World Problems And Solutions

LET’S START APPLYING EXCEL VBA TO REAL WORLD PROBLEMS

You’re not an Excel VBA Absolute Beginner. Rather, you’ve learned a few techniques and you feel ready to put them into action. Perhaps, like many, you’ve learned too many techniques and feel it’s about time to start applying Excel VBA to Real World Problems! After all, you didn’t learn to code for the sake of code itself. Or, perhaps you’d just like to hang out online for the next 30 days and talk Excel and Excel VBA? If any of these apply, you’ll love the Excel VBA For Beginners: 30 Real World Problems and Solutions series.

Video 1 – How To Create An Informative Message At The End Of A Macro Using Excel VBA

Video 2 – How To Find the Nth Largest Value In A Dataset Using Excel VBA

Video 3 – How To Edit A Database With A Button On A Row Using Excel VBA

Video 4 – How To Do A Custom Sort In Excel Using Excel VBA

Video 5 – How To Send Multiple Emails Using Excel VBA

Video 6 – Use Excel VBA To Delete Shapes On A Sheet, But Leave Some!

Video 7 – Use Excel VBA To Find The Last Row In A Dataset

Video 8 – List Unique Values In A Dataset Using Excel VBA

Video 9 - Automate Cell Comment Creation Using Excel VBA

Video 10 - Use Excel VBA To Delete Sheets In A File (But Leave Some!)

Video 11 - Use The VBA Format Function To Create 'Last Updated: ' Cell

Video 12 - Use Excel VBA To Move Data From A Template To A Database In Excel

Video 13 - Use Excel VBA To Create One Button Per Row

Video 14 - Use Excel VBA to Match To The Nearest Date

Video 15 - Create Multiple Tick Boxes And Link To Cells

Video 16 - Move Data To Other Files

https://www.youtube.com/embed/CYaXdLU_fMI

Video 17 - Store The 'Best Found So Far' Using A Variable (BOTD)

https://www.youtube.com/embed/6CuBD3JnlFc

Video 18 - Lookup A Value (Without a Formula!)

Video 19 - Format A Range According To A 'Setting' Cell

Video 20 - Make Excel VBA Code Excute Efficiently

Video 21 - Transfer Data Multiple Cells In One Range

Video 22 - Find the dimensions of a dataset

Video 23 - Get The Row In A Range Of A Target Value (Match)

Video 24 - 'Push' Data From A Database To Table

Video 25 - Generate Random Data (Football Simulation)

Video 26 - Clear Data On A Sheet Or Sheets In A File

Video 27 - Create A Message Box For Confirmation

Video 28 - Extend A Selection (For Formatting)// Whole Column From This Cell

Video 29 - Update User During Code Execution

Video 30 - Create A Manager Or Admin With A Password

https://www.youtube.com/embed/EbGZH0RiMDw