| 00 Introduction | |||
| 0001 Welcome.mov | 4.7 MB | ||
| 0002 Using the exercise files.mov | 279.59 KB | ||
| 01 Introducing Visual Basic for Applications | |||
| 0101 Introducing object-oriented programming.mov | 1.62 MB | ||
| 0102 Examining the Excel object model.mov | 3.59 MB | ||
| 0103 Working in the Visual Basic editor.mov | 4.98 MB | ||
| 0104 Setting VBA project properties.mov | 2.38 MB | ||
| 0105 Creating, exporting, and deleting code modules.mov | 6.57 MB | ||
| 0106 Creating a subroutine or function.mov | 5.74 MB | ||
| 0107 Controlling procedure scope and visibility.mov | 3.28 MB | ||
| 0108 Adding comments to the code.mov | 3.54 MB | ||
| 0109 Running a VBA routine.mov | 4.59 MB | ||
| 0110 Adding code to a recorded macro.mov | 3.18 MB | ||
| 02 Defining Variables, Constants, and Calculations | |||
| 0201 Introducing Excel VBA data types.mov | 6.72 MB | ||
| 0202 Declaring variables and requiring declaration before use.mov | 4.19 MB | ||
| 0203 Managing variable scope.mov | 3.71 MB | ||
| 0204 Defining static variables and constants.mov | 5.07 MB | ||
| 0205 Creating a calculation using mathematical operators.mov | 3.55 MB | ||
| 0206 Defining arrays.mov | 7.06 MB | ||
| 0207 Defining and using object variables.mov | 2.78 MB | ||
| 0208 Streamlining code references using With End With statements.mov | 3.6 MB | ||
| 03 Adding Logic to Your VBA Code | |||
| 0301 Repeating a task using a For Next loop.mov | 2.49 MB | ||
| 0302 Stepping through all items of a collection using a For Each loop.mov | 3.05 MB | ||
| 0303 Repeating a task with a Do loop.mov | 5.3 MB | ||
| 0304 Performing a task when conditions are met using If Then.mov | 7.18 MB | ||
| 0305 Selecting which action to take using a Case statement.mov | 1.76 MB | ||
| 04 Debugging You VBA Code | |||
| 0401 Managing errors using On Error statements.mov | 4.68 MB | ||
| 0402 Stepping through a subroutine or function.mov | 5.64 MB | ||
| 0403 Setting breakpoints in the code.mov | 2.57 MB | ||
| 0404 Verifying output using the Immediate window.mov | 3.82 MB | ||
| 0405 Watching a value in a routine.mov | 2.94 MB | ||
| 05 Managing Workbook Elements and Data in VBA | |||
| 0501 Writing a value to a cell.mov | 3.62 MB | ||
| 0502 Cutting, copying, and pasting cell data.mov | 5.14 MB | ||
| 0503 Finding values in cells.mov | 4.21 MB | ||
| 0504 Referring to cells using the Offset function.mov | 2.97 MB | ||
| 0505 Concatenating text strings.mov | 4.01 MB | ||
| 0506 Returning part of a string.mov | 2.83 MB | ||
| 0507 Managing worksheets with VBA.mov | 5.59 MB | ||
| 0508 Managing workbooks with VBA.mov | 3.89 MB | ||
| 06 Adding Advanced Elements to Your Workbook | |||
| 0601 Turning off screen updating within a macro.mov | 2.54 MB | ||
| 0602 Using worksheet functions in a macro.mov | 2.38 MB | ||
| 0603 Acquiring values using an input box or message box.mov | 5.13 MB | ||
| 0604 Calling a subroutine from another subroutine.mov | 2.02 MB | ||
| 07 Using Excel Events in Your VBA Code | |||
| 0701 Running a procedure when you open, close, or save a workbook.mov | 4.32 MB | ||
| 0702 Running a procedure when a cell range changes.mov | 4.58 MB | ||
| 0703 Triggering a procedure using a specific key sequence.mov | 3.71 MB | ||
| 08 Putting it All Together | |||
| 0801 Applying techniques in a Capstone project.mov | 6.06 MB | ||
| 09 Conclusion | |||
| 0901 Goodbye.mov | 250.85 KB | ||
| Exercise Files | |||
| Ch01 | |||
| Comments.xlsm | 39.93 KB | ||
| Commission.xlsm | 37.55 KB | ||
| ModulesManaged.xlsm | 9.9 KB | ||
| ProjectProperties.xlsm | 15.95 KB | ||
| RecordFirst.xlsm | 17.88 KB | ||
| RunAMacro.xlsm | 39.1 KB | ||
| Scope.xlsm | 41.37 KB | ||
| Scope.xlsx | 37.45 KB | ||
| VBEditor.xlsm | 13.86 KB | ||
| VBEditor.xlsx | 9.81 KB | ||
| Ch02 | |||
| ConstantStatic.xlsm | 39.81 KB | ||
| DimVariables.xlsm | 39.04 KB | ||
| MonthlySales.xlsm | 18.4 KB | ||
| Operators.xlsm | 40.74 KB | ||
| ShippingCharges.xlsm | 18.27 KB | ||
| Types.xlsm | 15.95 KB | ||
| VariableScope.xlsm | 37.72 KB | ||
| WithExample.xlsm | 8.98 KB | ||
| Ch03 | |||
| Case.xlsm | 38.94 KB | ||
| ForEach.xlsm | 18.46 KB | ||
| ForNext.xlsm | 17.45 KB | ||
| IfThen.xlsm | 39.46 KB | ||
| Suggestions.xlsm | 40.44 KB | ||
| Ch04 | |||
| Breaking.xlsm | 41.93 KB | ||
| CheckError.xlsm | 13.46 KB | ||
| Immediate.xlsm | 42.31 KB | ||
| Stepping.xlsm | 42.6 KB | ||
| Watch.xlsm | 16.77 KB | ||
| Ch05 | |||
| Concatenate.xlsm | 15.42 KB | ||
| CutPaste.xlsm | 17.31 KB | ||
| CutStrings.xlsm | 12.46 KB | ||
| Find.xlsm | 13.39 KB | ||
| Offset.xlsm | 39.83 KB | ||
| Workbooks.xlsm | 12.44 KB | ||
| Worksheets.xlsm | 38.42 KB | ||
| Writing.xlsm | 39.84 KB | ||
| Ch06 | |||
| Boxes.xlsm | 40.83 KB | ||
| Calling.xlsm | 40.46 KB | ||
| Flashing.xlsm | 41.41 KB | ||
| WorksheetFunctions.xlsm | 38.79 KB | ||
| Ch07 | |||
| ChangeRange.xlsm | 39.41 KB | ||
| ManipulateWorkbook.xlsm | 41.33 KB | ||
| OnKey.xlsm | 39.55 KB | ||
| Ch08 | |||
| Capstone.xlsm | 45.5 KB |
Lynda - Excel VBA in Depth with Curt Frye
Uploaded in Nov 15, 2014 By 2boweb
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
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Lynda - Setting Up a Database in Excel 2010 with Dennis Taylor Posted by
2boweb in Movies
> Other Movies
|
111.81 MB | 2boweb | 11 years | 1 | 0 |
|
Lynda com - Financial Analysis Analyzing the Top Line with Excel Posted by
pitsosnikos in Movies
> Other Movies
|
534.35 MB | pitsosnikos | 12 years | 2 | 0 |
| 918.67 MB | doduykhuong | 13 years | 1 | 0 | |
| 2.42 GB | azda | 13 years | 0 | 1 | |
| 378.72 MB | arman258 | 13 years | 0 | 0 |
All Comments