How to Write VBA Macros in Excel

Learn how to write VBA macros in Excel! This four-part course provides participants the skills to incorporate Visual Basic for Applications (VBA) into financial models. This VBA module series will be particularly valuable to those who regularly build financial models in Excel and are looking for a thorough introduction to VBA. This video tutorial is from our FULL course: http://courses.corporatefinanceinstitute.com/courses/financial-modeling-using-vba-online-course. Enroll today and earn a certificate to advance your career! Chapters: 00:00 - Financial Modeling in VBA - Module 1 00:37 - Before Continuing 02:09 - Visual Basic for Applications (VBA) 03:20 - Recording Macros Overview 05:06 - The Visual Basic Editor (VBE) 12:13 - Absolute Referencing Example 12:46 - Exercise 17:37 - Relative Referencing Example 22:15 - Testing the Macro and Debugging 22:52 - Fixing the "Subscript out of Range" Error 25:48 - Limitations of the Macro Recorder 26:44 - Module 1 Conclusion FREE COURSES & CERTIFICATES Enroll in our FREE online courses and earn industry-recognized certificates to advance your career: ► Introduction to Corporate Finance: https://loom.ly/us5oJEw ► Excel Fundamentals: https://loom.ly/4KnYciU ► Accounting Fundamentals: https://loom.ly/xHJgJO4 ► Reading Financial Statements: https://loom.ly/2wrcPw8 ► Fixed Income Fundamentals: https://loom.ly/DZdjDA0 About Corporate Finance Institute: CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the world's top universities, investment banks, accounting firms, and operating companies. By taking our courses, you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical, with step-by-step instructions to help you become a first-class financial analyst. Explore CFI courses: https://courses.corporatefinanceinstitute.com/collections Join us on social media! LinkedIn: https://www.linkedin.com/company/corporate-finance-institute-cfi Facebook: https://www.facebook.com/corporatefinanceinstitute.cfi Instagram: https://www.instagram.com/corporatefinanceinstitute #VBAMacros #Excel #FinancialModeling #VisualBasicForApplications