InfiniteSkills Learning Visual Basic for Microsoft Excel | 44384544A6426DE19EB95BCC4C4612C9C2DE960E

InfiniteSkills Learning Visual Basic for Microsoft Excel

Name	InfiniteSkills - Learning Visual Basic for Microsoft Excel	DOWNLOAD Copy Link
Total Size	996.4 MB
Total Files	184
Hash	44384544A6426DE19EB95BCC4C4612C9C2DE960E

/Working Files/Chapter 1/
sampleMacro.xlsm	18.0 KB
/Working Files/Chapter 10/
checkBox.xlsm	14.5 KB
formTemplate.xlsm	14.0 KB
formTemplate_Complete.xlsm	15.7 KB
formTemplate_Complete_withAlignmentDone.xlsm	17.6 KB
InputBox.xlsm	8.4 KB
InputBox_result.xlsm	14.9 KB
labelsandtextBoxes.xlsm	14.4 KB
listboxComboBox.xlsm	15.5 KB
msgBox.xlsm	8.4 KB
msgBox_result.xlsm	14.9 KB
multipleTabs.xlsm	17.5 KB
rangeSelect_result.xlsm	14.2 KB
refEdit.xlsm	18.0 KB
scrollbarandSpinControls.xlsm	14.9 KB
userFormExample.xlsm	20.7 KB
userFormStage2.xlsm	15.5 KB
userFormStage3.xlsm	16.1 KB
userFormStage4.xlsm	17.4 KB
userFormStage4_result.xlsm	43.6 KB
userFormStart.xlsm	13.6 KB
userformwithImages.xlsm	190.2 KB
/Working Files/Chapter 11/
changeCaseProcedure.xlsm	19.7 KB
/Working Files/Chapter 2/
myfirstMacro.xlsm	19.7 KB
/Working Files/Chapter 3/
degreesFunction.xlsm	14.5 KB
degreesFunction_Result.xlsm	15.5 KB
sample_Sub.xlsm	17.9 KB
/Working Files/Chapter 4/
constants.xlsm	13.4 KB
exampleScoping.xlsm	13.8 KB
exampleScoping_Result.xlsm	13.4 KB
exampleVariables.xlsm	13.6 KB
exampleVariables_Result.xlsm	13.8 KB
operators.xlsm	12.6 KB
staticVariable.xlsm	13.7 KB
stringanddateExpanded_Result.xlsm	15.5 KB
vba_DataTypes.pdf	274.1 KB
/Working Files/Chapter 5/
colorAndFont.xlsm	15.6 KB
colorAndFont_result.xlsm	16.7 KB
formulas.xlsm	12.9 KB
formulas_Result.xlsm	15.0 KB
methods.xlsm	13.2 KB
methods_Result.xlsm	16.8 KB
numberFormats.xlsm	9.0 KB
numberFormats_result.xlsm	16.0 KB
RangeObject.xlsm	12.9 KB
rangeTesting.xlsm	13.4 KB
readonlyProperties_results.xlsm	14.9 KB
textProperty.xlsm	13.8 KB
/Working Files/Chapter 6/
excelFunctions.xlsm	12.9 KB
excelFunctions_Result.xlsm	15.2 KB
sample.xlsm	16.2 KB
/Working Files/Chapter 7/
caseSelect.xlsm	14.1 KB
caseSelect_Result.xlsm	14.6 KB
doWHile_Result.xlsm	14.0 KB
foreachCollection.xlsm	12.1 KB
foreachCollection_Result.xlsm	15.0 KB
forNext.xlsm	8.4 KB
forNext_Result.xlsm	15.2 KB
IF.xlsm	14.0 KB
IF_ESLEIF_Result.xlsm	14.1 KB
IF_result.xlsm	14.1 KB
If_Then_Else.xlsm	13.9 KB
/Working Files/Chapter 8/
keyPress.xlsm	16.4 KB
keyPressResult.xlsm	16.7 KB
OpenCloseEvent.xlsm	9.4 KB
OpenCloseEvent_CloseTrigger.xlsm	16.4 KB
OpenCloseEvent_OpenTrigger.xlsm	16.0 KB
OpenCloseEvent_OpenTrigger_test.xlsm	15.9 KB
speakingSheet.xlsm	15.3 KB
WorkBookEvents.xlsm	10.0 KB
WorkBookEvents_SheetActivateandDeactivate.xlsm	16.2 KB
worksheetActivate.xlsm	10.2 KB
worksheetActivate_result.xlsm	16.5 KB
worksheetTriggers.xlsm	14.9 KB
worksheetTriggers_result.xlsm	17.1 KB
/Working Files/Chapter 9/
breakpoints.xlsm	15.4 KB
breakpoints_Result.xlsm	15.6 KB
debugOutput.xlsm	14.9 KB
debugOutput_Result.xlsm	15.4 KB
errorTrap.xlsm	13.9 KB
errorTrap_Result.xlsm	14.5 KB
errorTrapError.xlsm	14.8 KB
errorTrapError_result.xlsm	15.4 KB
errorTrapResume.xlsm	14.6 KB
errorTrapResume_Result.xlsm	14.9 KB
errorTrapResumeLabel.xlsm	14.5 KB
errorTrapResumeLabel_result.xlsm	15.4 KB
errorTrapResumeWithLabel.xlsm	14.9 KB
errorTrapResumeWithLabel_result.xlsm	15.6 KB
sampleworkbook.xlsx	8.5 KB
speedTips.xlsm	16.9 KB
speedTips.xlsx	8.3 KB
speedTips_Result.xlsm	59.5 KB
watches.xlsm	15.5 KB
watches_result.xlsm	15.7 KB
/
0101.What Will I Get Out Of This Course.mp4	16.5 MB
0102.About The Author.mp4	2.3 MB
0103.The Working Files Explained.mp4	6.2 MB
0104.What Is VBA.mp4	5.6 MB
0105.Excel 2010 Security Settings And Macro Files.mp4	15.1 MB
0106.The Developer Ribbon.mp4	8.7 MB
0201.Recording And Running A Simple Macro.mp4	20.2 MB
0202.Editing An Existing Macro In The Visual Basic Editor.mp4	11.3 MB
0203.The New Macro Enabled File Type.mp4	8.6 MB
0204.Quick Tour Of The Visual Basic Editor.mp4	11.0 MB
0205.Watch A Macro Write Your VBA.mp4	9.8 MB
0301.What Is A Module.mp4	7.5 MB
0302.Creating A Sub Procedure Manually.mp4	5.2 MB
0303.How To Call A Sub Procedure.mp4	6.3 MB
0304.Creating A Function Procedure.mp4	4.2 MB
0305.How To Call A Function.mp4	6.0 MB
0401.Using Comments Within Your VBA Code.mp4	7.9 MB
0402.Declaring Variables And Data Types.mp4	13.7 MB
0403.The Scope Of A Variable.mp4	8.6 MB
0404.The Static Declaration And Variable Expiry.mp4	11.2 MB
0405.Constants Instead Of Variables.mp4	5.6 MB
0406.An Intrinsic Constant.mp4	7.1 MB
0407.String And Date Types Expanded.mp4	9.3 MB
0408.VBA Operators.mp4	14.3 MB
0409.Arrays.mp4	7.4 MB
0410.Multi-Dimensional Arrays.mp4	4.8 MB
0411.Dynamic Arrays.mp4	5.5 MB
0501.Referencing Cells Using The Range Object.mp4	6.7 MB
0502.The CELLS Property.mp4	4.0 MB
0503.The OFFSET Property.mp4	3.5 MB
0504.The VALUE Of Ranges.mp4	19.1 MB
0505.The TEXT Object Of The RANGE.mp4	8.7 MB
0506.A Number Of Read Only RANGE Properties.mp4	14.6 MB
0507.The FONT Property And Colors.mp4	12.9 MB
0508.Formatting Numeric Values.mp4	6.8 MB
0509.Add Formulas To Cells Through VBA Code.mp4	10.7 MB
0510.Common METHODS Of The RANGE Object.mp4	20.3 MB
0601.What Is A Function.mp4	2.2 MB
0602.Built In VBA Date Functions.mp4	4.3 MB
0603.Text Manipulation With VBA Functions.mp4	12.8 MB
0604.Determining File Sizes Using FILELEN.mp4	6.4 MB
0605.Using Worksheet Excel Functions In VBA Code.mp4	14.0 MB
0606.User Defined Functions.mp4	7.5 MB
0701.Using GOTO And Labels.mp4	6.2 MB
0702.Controlling The Program Flow With IF THEN ELSE.mp4	6.4 MB
0703.Multiple Criteria Plus Nested IFs.mp4	8.6 MB
0704.Adding ELSEIF To Speed Up Execution.mp4	6.2 MB
0705.SELECT CASE As An Alternative To IF.mp4	10.5 MB
0706.The FOR NEXT Loop.mp4	13.9 MB
0707.FOR NEXT With A VBA Collection.mp4	16.4 MB
0708.DO WHILE Loop.mp4	9.5 MB
0801.How To Create An Event.mp4	13.0 MB
0802.WorkBook Events - Open.mp4	17.5 MB
0803.Workbook Events - Closing And Saving.mp4	18.4 MB
0804.Workbook Triggers - Activate And Deactivate.mp4	9.4 MB
0805.Worksheet Triggers - Activate And Deactivate.mp4	6.9 MB
0806.Other Useful Worksheet Triggers.mp4	16.0 MB
0807.Using Application Events.mp4	28.1 MB
0901.Error Trapping the Easy Way.mp4	11.4 MB
0902.Make The VBA Ignore Errors.mp4	7.3 MB
0903.Interact With The User When An Error Occurs.mp4	8.3 MB
0904.Making Use Of The ERR Object.mp4	8.4 MB
0905.Debugging Techniques.mp4	15.9 MB
0906.Using Breakpoints To Help Debug.mp4	11.2 MB
0907.Setup And Use A Watch.mp4	9.7 MB
0908.Speeding Up The VBA Tips.mp4	29.4 MB
1001.Using MSGBOX To Interact With Users.mp4	16.7 MB
1002.Use INPUTBOX For Accepting Values From Users.mp4	12.6 MB
1003.Selecting A Range With The INPUT Box.mp4	5.9 MB
1004.An Introduction To UserForms.mp4	7.7 MB
1005.Creating A UserForm.mp4	9.2 MB
1006.Using Command Buttons.mp4	9.8 MB
1007.Adding Option Buttons In A Frame.mp4	14.1 MB
1008.Adding The Code That Makes The Form Work.mp4	17.9 MB
1009.Calling Your UserForm And Validating Content.mp4	23.3 MB
1010.UserForm Controls - The CheckBox.mp4	17.7 MB
1012.Images On UserForms.mp4	12.4 MB
1013.Labels And Text Boxes.mp4	11.3 MB
1014.Multiple Tabs On A UserForm.mp4	18.1 MB
1015.Allowing The User To Highlight A Range.mp4	8.2 MB
1016.Scrollbar And Spin Controls.mp4	19.0 MB
1017.Controlling Tab Order And Aligning Controls.mp4	20.5 MB
1101.Trigger A Procedure From The Quick Access Toolbar.mp4	14.8 MB
1102.Customizing The Ribbons.mp4	17.5 MB
1103.Adding Buttons To Sheets.mp4	9.2 MB
1104.Adding A Keyboard Shortcut Trigger.mp4	6.2 MB
1105.Where To Store Your VBA Code.mp4	19.4 MB
1106.Adding Code To The PERSONAL File.mp4	16.6 MB
1201.So What's Next.mp4	2.9 MB
Total files 184