Lynda - Learning VBA in Excel
Categories: Tutorials
Lynda - Learning VBA in Excel - 802840
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.


Table of Contents

  • 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

    • Lynda - Learning VBA in Excel
    Information
    Members of Guests cannot leave comments.


    Categories Sitemap



    rss