Watch How to Design and Code an Excel VBA Application Like a Pro Video Tutorial

👉 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/2UamvVh (Note: If the download page doesn't work then make sure to turn off any popup blockers) How to Design and Code an Excel VBA Application Like a Pro In this previous videos I have shown many tips and tricks for getting to the most out of Excel VBA. In this video I'm putting them all together and showing you how to design and write the code from and Excel VBA application. I've also included many little-known secrets that have never appeared in any of my youtube videos. Related Articles Excel VBA Copy – The Complete Guide to Copying Data(https://excelmacromastery.com/excel-vba-copy/) The Complete Guide to Ranges and Cells in Excel VBA(https://excelmacromastery.com/excel-vba-range-cells/) Excel VBA Array – The Complete Guide(https://excelmacromastery.com/excel-vba-array/) Useful VBA Shortcut Keys ======================== Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Compile the code: Alt + D + C 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) View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H 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 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R 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 View the Properties Window: F4