Sports Fixtures Generator - A Real-World VBA Application

👉 Ready to master VBA? - Check out my full courses: https://courses.excelmacromastery.com/ - Subscribe to the channel here: https://bit.ly/36hpTCY -Want to download the source code for this video? Go here: https://bit.ly/3ANdrfg (Note: If the download page doesn't work then make sure to turn off any popup blockers) Sports Fixtures Generator - A Real-World VBA Application In this video, I create a sports fixture generator using Excel VBA code. This application takes a list of teams and generates fixtures for a league. It works for any number of teams and you can set the number of times the teams meet. The video covers professional quality VBA techniques which you can use in your own applications. #excelvba #excelvbacopy #SportsFixtureGenerator #RealWorldVBA (Blog Post)Excel VBA Copy – The Complete Guide to Copying Data: https://excelmacromastery.com/excel-vba-copy/ (Blog Post)VBA Advanced Filter: A Complete Guide: https://excelmacromastery.com/vba-advanced-filter/ (Blog Post)Excel VBA Array – The Complete Guide: https://excelmacromastery.com/excel-vba-array/ YouTube Video: How to use ADO and VBA to Read from Worksheets: https://youtu.be/L0I24NGrUtc YouTube PlayList: Excel VBA Copying and Filtering Data: https://youtube.com/playlist?list=PL7ScsebMq5uV493VqnVEIY35SKxUKwWHM YouTube PlayList: Excel VBA Arrays: https://youtube.com/playlist?list=PL7ScsebMq5uV493VqnVEIY35SKxUKwWHM Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) Table of Contents: 00:00 - Introduction 00:42 - Application Demo 02:39 - Adding the Click events 05:53 - How to generate fixtures 13:29 - Creating Starting array 15:45 - Create fixtures 17:12 - Rotate Teams 19:12 - Copy the current round 23:35 - Print out the fixtures