Lynda - Learning VBA in Excel

Lynda - Learning VBA in Excel

The Visual Basic for Applications (VBA) programming language allows you to automate routine tasks in Excel—and it's not as hard to learn as most people think. In this course, Excel expert Curt Frye offers a crash course on VBA, sharing techniques that can help users of Excel 2007 or later get more out of this powerful program. Curt covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.

https://www.lynda.com/Excel-tutorials/Learning-VBA-Excel/802840-2.html

Introduction

1. Visual Basic for Applications

2. Defining Variables, Constants, and Calculations

3. Adding Logic to Your VBA Code

4. Debugging Your VBA Code

5. Managing Workbook Elements and Data in VBA

6. Adding Advanced Elements to Your Workbook

7. Using Excel Events in Your VBA Code

8. Putting It All Together

Conclusion

Table of Contents

Would you like to be a Author?