Lynda Excel VBA in Depth with Curt Frye | D7A833256532CB056154C8875B932A51983D28F5

Lynda Excel VBA in Depth with Curt Frye

Name	Lynda - Excel VBA in Depth with Curt Frye	DOWNLOAD Copy Link
Total Size	194.1 MB
Total Files	91
Last Seen	2024-11-14 23:46
Hash	D7A833256532CB056154C8875B932A51983D28F5

/03 Adding Logic to Your VBA Code/
0304 Performing a task when conditions are met using If Then.mov	7.5 MB
0303 Repeating a task with a Do loop.mov	5.6 MB
0302 Stepping through all items of a collection using a For Each loop.mov	3.2 MB
0301 Repeating a task using a For Next loop.mov	2.6 MB
0305 Selecting which action to take using a Case statement.mov	1.8 MB
/02 Defining Variables, Constants, and Calculations/
0206 Defining arrays.mov	7.4 MB
0201 Introducing Excel VBA data types.mov	7.0 MB
0204 Defining static variables and constants.mov	5.3 MB
0202 Declaring variables and requiring declaration before use.mov	4.4 MB
0203 Managing variable scope.mov	3.9 MB
0208 Streamlining code references using With End With statements.mov	3.8 MB
0205 Creating a calculation using mathematical operators.mov	3.7 MB
0207 Defining and using object variables.mov	2.9 MB
/01 Introducing Visual Basic for Applications/
0105 Creating, exporting, and deleting code modules.mov	6.9 MB
0106 Creating a subroutine or function.mov	6.0 MB
0103 Working in the Visual Basic editor.mov	5.2 MB
0109 Running a VBA routine.mov	4.8 MB
0102 Examining the Excel object model.mov	3.8 MB
0108 Adding comments to the code.mov	3.7 MB
0107 Controlling procedure scope and visibility.mov	3.4 MB
0110 Adding code to a recorded macro.mov	3.3 MB
0104 Setting VBA project properties.mov	2.5 MB
0101 Introducing object-oriented programming.mov	1.7 MB
/08 Putting it All Together/
0801 Applying techniques in a Capstone project.mov	6.4 MB
/04 Debugging You VBA Code/
0402 Stepping through a subroutine or function.mov	5.9 MB
0401 Managing errors using On Error statements.mov	4.9 MB
0404 Verifying output using the Immediate window.mov	4.0 MB
0405 Watching a value in a routine.mov	3.1 MB
0403 Setting breakpoints in the code.mov	2.7 MB
/05 Managing Workbook Elements and Data in VBA/
0507 Managing worksheets with VBA.mov	5.9 MB
0502 Cutting, copying, and pasting cell data.mov	5.4 MB
0503 Finding values in cells.mov	4.4 MB
0505 Concatenating text strings.mov	4.2 MB
0508 Managing workbooks with VBA.mov	4.1 MB
0501 Writing a value to a cell.mov	3.8 MB
0504 Referring to cells using the Offset function.mov	3.1 MB
0506 Returning part of a string.mov	3.0 MB
/06 Adding Advanced Elements to Your Workbook/
0603 Acquiring values using an input box or message box.mov	5.4 MB
0601 Turning off screen updating within a macro.mov	2.7 MB
0602 Using worksheet functions in a macro.mov	2.5 MB
0604 Calling a subroutine from another subroutine.mov	2.1 MB
/00 Introduction/
0001 Welcome.mov	4.9 MB
0002 Using the exercise files.mov	286.3 KB
/07 Using Excel Events in Your VBA Code/
0702 Running a procedure when a cell range changes.mov	4.8 MB
0701 Running a procedure when you open, close, or save a workbook.mov	4.5 MB
0703 Triggering a procedure using a specific key sequence.mov	3.9 MB
/09 Conclusion/
0901 Goodbye.mov	256.9 KB
/Exercise Files/Ch08/
Capstone.xlsm	46.6 KB
/Exercise Files/Ch04/
Stepping.xlsm	43.6 KB
Immediate.xlsm	43.3 KB
Breaking.xlsm	42.9 KB
Watch.xlsm	17.2 KB
CheckError.xlsm	13.8 KB
/Exercise Files/Ch06/
Flashing.xlsm	42.4 KB
Boxes.xlsm	41.8 KB
Calling.xlsm	41.4 KB
WorksheetFunctions.xlsm	39.7 KB
/Exercise Files/Ch01/
Scope.xlsm	42.4 KB
Comments.xlsm	40.9 KB
RunAMacro.xlsm	40.0 KB
Commission.xlsm	38.5 KB
Scope.xlsx	38.4 KB
RecordFirst.xlsm	18.3 KB
ProjectProperties.xlsm	16.3 KB
VBEditor.xlsm	14.2 KB
ModulesManaged.xlsm	10.1 KB
VBEditor.xlsx	10.0 KB
/Exercise Files/Ch07/
ManipulateWorkbook.xlsm	42.3 KB
OnKey.xlsm	40.5 KB
ChangeRange.xlsm	40.4 KB
/Exercise Files/Ch02/
Operators.xlsm	41.7 KB
ConstantStatic.xlsm	40.8 KB
DimVariables.xlsm	40.0 KB
VariableScope.xlsm	38.6 KB
MonthlySales.xlsm	18.8 KB
ShippingCharges.xlsm	18.7 KB
Types.xlsm	16.3 KB
WithExample.xlsm	9.2 KB
/Exercise Files/Ch03/
Suggestions.xlsm	41.4 KB
IfThen.xlsm	40.4 KB
Case.xlsm	39.9 KB
ForEach.xlsm	18.9 KB
ForNext.xlsm	17.9 KB
/Exercise Files/Ch05/
Writing.xlsm	40.8 KB
Offset.xlsm	40.8 KB
Worksheets.xlsm	39.3 KB
CutPaste.xlsm	17.7 KB
Concatenate.xlsm	15.8 KB
Find.xlsm	13.7 KB
CutStrings.xlsm	12.8 KB
Workbooks.xlsm	12.7 KB
Total files 91