2010
Lynda
Curt Frye
3:00
English

In Up and Running with VBA in Excel, Excel and VBA expert Curt Frye introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance Excel performance and efficiency. This course introduces the Visual Basic for Applications programming language, covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel 2007 object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.

Introduction
Welcome
Using the exercise files
1. Introducing Visual Basic for Applications (VBA)
Introducing object-oriented programming
Examining the Excel object model
Working in the Visual Basic editor
Setting VBA project properties
Creating, exporting, and deleting code modules
Creating a subroutine or function
Controlling procedure scope and visibility
Adding comments to the code
Running a VBA routine
Adding code to a recorded macro
2. Defining Variables, Constants, and Calculations
Introducing Excel VBA data types
Declaring variables and requiring declaration before use
Managing variable scope
Defining static variables and constants
Creating a calculation using mathematical operators
Defining arrays
Defining and using object variables
Streamlining code references using With...End With statements
3. Adding Logic to Your VBA Code
Repeating a task using a For...Next loop
Stepping through all items of a collection using a For...Each loop
Repeating a task with a Do loop
Performing a task when conditions are met using If...Then
Selecting which action to take using a Case statement
4. Debugging Your VBA Code
Managing errors using On Error statements
Stepping through a subroutine or function
Setting breakpoints in the code
Verifying output using the Immediate window
Watching a value in a routine
5. Managing Workbook Elements and Data in VBA
Writing a value to a cell
Cutting, copying, and pasting cell data
Finding values in cells
Referring to cells using the Offset function
Concatenating text strings
Returning part of a string
Managing worksheets with VBA
Managing workbooks with VBA
6. Adding Advanced Elements to Your Workbook
Turning off screen updating within a macro
Using worksheet functions in a macro
Acquiring values using an input box or message box
Calling a subroutine from another subroutine
7. Using Excel Events in Your VBA Code
Running a procedure when you open, close, or save a workbook
Running a procedure when a cell range changes
Triggering a procedure using a specific key sequence
8. Putting It All Together
Applying techniques in a Capstone project
Conclusion
Goodbye

Download File Size:323.01 MB

---