In Excel: VBA in Depth, 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.
Topics include:
* Working in the Visual Basic Editor
* Adding code to a macro
* Creating, exporting, and deleting code modules
* Declaring and using variables
* Managing variable scope
* Defining arrays
* Managing workbooks and worksheets with VBA
* Repeating tasks with loops
* Debugging VBA code
* Cutting, copying, and pasting cell data
* Running and triggering event procedures
Download File Size:183.06 MB