InfiniteSkills - Learning Visual Basic for Microsoft Excel

mp4   Hot：490   Size：950.23 MB   Created：2017-08-26 23:26:45   Update：2021-12-11 17:05:42  

Download link

小提示：当迅雷提示“下载出错”或“无法下载”等字样时，并非资源有问题，请更换 bitcomet(比特彗星) 即可下载，或者使用迅雷5。

File List

  • Working Files/Chapter 1/sampleMacro.xlsm 17.56 KB
    Working Files/Chapter 10/checkBox.xlsm 14.16 KB
    Working Files/Chapter 10/formTemplate.xlsm 13.66 KB
    Working Files/Chapter 10/formTemplate_Complete.xlsm 15.29 KB
    Working Files/Chapter 10/formTemplate_Complete_withAlignmentDone.xlsm 17.22 KB
    Working Files/Chapter 10/InputBox.xlsm 8.22 KB
    Working Files/Chapter 10/InputBox_result.xlsm 14.53 KB
    Working Files/Chapter 10/labelsandtextBoxes.xlsm 14.03 KB
    Working Files/Chapter 10/listboxComboBox.xlsm 15.11 KB
    Working Files/Chapter 10/msgBox.xlsm 8.22 KB
    Working Files/Chapter 10/msgBox_result.xlsm 14.55 KB
    Working Files/Chapter 10/multipleTabs.xlsm 17.06 KB
    Working Files/Chapter 10/rangeSelect_result.xlsm 13.89 KB
    Working Files/Chapter 10/refEdit.xlsm 17.61 KB
    Working Files/Chapter 10/scrollbarandSpinControls.xlsm 14.58 KB
    Working Files/Chapter 10/userFormExample.xlsm 20.17 KB
    Working Files/Chapter 10/userFormStage2.xlsm 15.17 KB
    Working Files/Chapter 10/userFormStage3.xlsm 15.71 KB
    Working Files/Chapter 10/userFormStage4.xlsm 17.01 KB
    Working Files/Chapter 10/userFormStage4_result.xlsm 42.58 KB
    Working Files/Chapter 10/userFormStart.xlsm 13.32 KB
    Working Files/Chapter 10/userformwithImages.xlsm 185.76 KB
    Working Files/Chapter 11/changeCaseProcedure.xlsm 19.27 KB
    Working Files/Chapter 2/myfirstMacro.xlsm 19.22 KB
    Working Files/Chapter 3/degreesFunction.xlsm 14.11 KB
    Working Files/Chapter 3/degreesFunction_Result.xlsm 15.18 KB
    Working Files/Chapter 3/sample_Sub.xlsm 17.52 KB
    Working Files/Chapter 4/constants.xlsm 13.12 KB
    Working Files/Chapter 4/exampleScoping.xlsm 13.44 KB
    Working Files/Chapter 4/exampleScoping_Result.xlsm 13.13 KB
    Working Files/Chapter 4/exampleVariables.xlsm 13.31 KB
    Working Files/Chapter 4/exampleVariables_Result.xlsm 13.45 KB
    Working Files/Chapter 4/operators.xlsm 12.31 KB
    Working Files/Chapter 4/staticVariable.xlsm 13.38 KB
    Working Files/Chapter 4/stringanddateExpanded_Result.xlsm 15.16 KB
    Working Files/Chapter 4/vba_DataTypes.pdf 267.69 KB
    Working Files/Chapter 5/colorAndFont.xlsm 15.24 KB
    Working Files/Chapter 5/colorAndFont_result.xlsm 16.3 KB
    Working Files/Chapter 5/formulas.xlsm 12.6 KB
    Working Files/Chapter 5/formulas_Result.xlsm 14.67 KB
    Working Files/Chapter 5/methods.xlsm 12.89 KB
    Working Files/Chapter 5/methods_Result.xlsm 16.44 KB
    Working Files/Chapter 5/numberFormats.xlsm 8.8 KB
    Working Files/Chapter 5/numberFormats_result.xlsm 15.63 KB
    Working Files/Chapter 5/RangeObject.xlsm 12.64 KB
    Working Files/Chapter 5/rangeTesting.xlsm 13.09 KB
    Working Files/Chapter 5/readonlyProperties_results.xlsm 14.59 KB
    Working Files/Chapter 5/textProperty.xlsm 13.5 KB
    Working Files/Chapter 6/excelFunctions.xlsm 12.59 KB
    Working Files/Chapter 6/excelFunctions_Result.xlsm 14.86 KB
    Working Files/Chapter 6/sample.xlsm 15.85 KB
    Working Files/Chapter 7/caseSelect.xlsm 13.78 KB
    Working Files/Chapter 7/caseSelect_Result.xlsm 14.26 KB
    Working Files/Chapter 7/doWHile_Result.xlsm 13.67 KB
    Working Files/Chapter 7/foreachCollection.xlsm 11.85 KB
    Working Files/Chapter 7/foreachCollection_Result.xlsm 14.61 KB
    Working Files/Chapter 7/forNext.xlsm 8.22 KB
    Working Files/Chapter 7/forNext_Result.xlsm 14.82 KB
    Working Files/Chapter 7/IF.xlsm 13.71 KB
    Working Files/Chapter 7/IF_ESLEIF_Result.xlsm 13.78 KB
    Working Files/Chapter 7/IF_result.xlsm 13.73 KB
    Working Files/Chapter 7/If_Then_Else.xlsm 13.56 KB
    Working Files/Chapter 8/keyPress.xlsm 16 KB
    Working Files/Chapter 8/keyPressResult.xlsm 16.32 KB
    Working Files/Chapter 8/OpenCloseEvent.xlsm 9.16 KB
    Working Files/Chapter 8/OpenCloseEvent_CloseTrigger.xlsm 15.97 KB
    Working Files/Chapter 8/OpenCloseEvent_OpenTrigger.xlsm 15.59 KB
    Working Files/Chapter 8/OpenCloseEvent_OpenTrigger_test.xlsm 15.57 KB
    Working Files/Chapter 8/speakingSheet.xlsm 14.94 KB
    Working Files/Chapter 8/WorkBookEvents.xlsm 9.8 KB
    Working Files/Chapter 8/WorkBookEvents_SheetActivateandDeactivate.xlsm 15.81 KB
    Working Files/Chapter 8/worksheetActivate.xlsm 9.99 KB
    Working Files/Chapter 8/worksheetActivate_result.xlsm 16.11 KB
    Working Files/Chapter 8/worksheetTriggers.xlsm 14.55 KB
    Working Files/Chapter 8/worksheetTriggers_result.xlsm 16.7 KB
    Working Files/Chapter 9/breakpoints.xlsm 15.08 KB
    Working Files/Chapter 9/breakpoints_Result.xlsm 15.26 KB
    Working Files/Chapter 9/debugOutput.xlsm 14.52 KB
    Working Files/Chapter 9/debugOutput_Result.xlsm 14.99 KB
    Working Files/Chapter 9/errorTrap.xlsm 13.55 KB
    Working Files/Chapter 9/errorTrap_Result.xlsm 14.11 KB
    Working Files/Chapter 9/errorTrapError.xlsm 14.43 KB
    Working Files/Chapter 9/errorTrapError_result.xlsm 15.05 KB
    Working Files/Chapter 9/errorTrapResume.xlsm 14.23 KB
    Working Files/Chapter 9/errorTrapResume_Result.xlsm 14.55 KB
    Working Files/Chapter 9/errorTrapResumeLabel.xlsm 14.15 KB
    Working Files/Chapter 9/errorTrapResumeLabel_result.xlsm 15.08 KB
    Working Files/Chapter 9/errorTrapResumeWithLabel.xlsm 14.51 KB
    Working Files/Chapter 9/errorTrapResumeWithLabel_result.xlsm 15.25 KB
    Working Files/Chapter 9/sampleworkbook.xlsx 8.32 KB
    Working Files/Chapter 9/speedTips.xlsm 16.47 KB
    Working Files/Chapter 9/speedTips.xlsx 8.14 KB
    Working Files/Chapter 9/speedTips_Result.xlsm 58.09 KB
    Working Files/Chapter 9/watches.xlsm 15.12 KB
    Working Files/Chapter 9/watches_result.xlsm 15.31 KB
    0101.What Will I Get Out Of This Course.mp4 15.76 MB
    0102.About The Author.mp4 2.21 MB
    0103.The Working Files Explained.mp4 5.89 MB
    0104.What Is VBA.mp4 5.36 MB
    0105.Excel 2010 Security Settings And Macro Files.mp4 14.43 MB
    0106.The Developer Ribbon.mp4 8.34 MB
    0201.Recording And Running A Simple Macro.mp4 19.29 MB
    0202.Editing An Existing Macro In The Visual Basic Editor.mp4 10.78 MB
    0203.The New Macro Enabled File Type.mp4 8.19 MB
    0204.Quick Tour Of The Visual Basic Editor.mp4 10.49 MB
    0205.Watch A Macro Write Your VBA.mp4 9.3 MB
    0301.What Is A Module.mp4 7.17 MB
    0302.Creating A Sub Procedure Manually.mp4 4.96 MB
    0303.How To Call A Sub Procedure.mp4 6.02 MB
    0304.Creating A Function Procedure.mp4 4.05 MB
    0305.How To Call A Function.mp4 5.71 MB
    0401.Using Comments Within Your VBA Code.mp4 7.57 MB
    0402.Declaring Variables And Data Types.mp4 13.08 MB
    0403.The Scope Of A Variable.mp4 8.21 MB
    0404.The Static Declaration And Variable Expiry.mp4 10.64 MB
    0405.Constants Instead Of Variables.mp4 5.33 MB
    0406.An Intrinsic Constant.mp4 6.77 MB
    0407.String And Date Types Expanded.mp4 8.84 MB
    0408.VBA Operators.mp4 13.63 MB
    0409.Arrays.mp4 7.04 MB
    0410.Multi-Dimensional Arrays.mp4 4.59 MB
    0411.Dynamic Arrays.mp4 5.26 MB
    0501.Referencing Cells Using The Range Object.mp4 6.4 MB
    0502.The CELLS Property.mp4 3.85 MB
    0503.The OFFSET Property.mp4 3.34 MB
    0504.The VALUE Of Ranges.mp4 18.21 MB
    0505.The TEXT Object Of The RANGE.mp4 8.29 MB
    0506.A Number Of Read Only RANGE Properties.mp4 13.95 MB
    0507.The FONT Property And Colors.mp4 12.35 MB
    0508.Formatting Numeric Values.mp4 6.47 MB
    0509.Add Formulas To Cells Through VBA Code.mp4 10.22 MB
    0510.Common METHODS Of The RANGE Object.mp4 19.39 MB
    0601.What Is A Function.mp4 2.14 MB
    0602.Built In VBA Date Functions.mp4 4.06 MB
    0603.Text Manipulation With VBA Functions.mp4 12.22 MB
    0604.Determining File Sizes Using FILELEN.mp4 6.15 MB
    0605.Using Worksheet Excel Functions In VBA Code.mp4 13.33 MB
    0606.User Defined Functions.mp4 7.16 MB
    0701.Using GOTO And Labels.mp4 5.92 MB
    0702.Controlling The Program Flow With IF THEN ELSE.mp4 6.09 MB
    0703.Multiple Criteria Plus Nested IFs.mp4 8.23 MB
    0704.Adding ELSEIF To Speed Up Execution.mp4 5.93 MB
    0705.SELECT CASE As An Alternative To IF.mp4 10.01 MB
    0706.The FOR NEXT Loop.mp4 13.27 MB
    0707.FOR NEXT With A VBA Collection.mp4 15.62 MB
    0708.DO WHILE Loop.mp4 9.07 MB
    0801.How To Create An Event.mp4 12.39 MB
    0802.WorkBook Events - Open.mp4 16.68 MB
    0803.Workbook Events - Closing And Saving.mp4 17.59 MB
    0804.Workbook Triggers - Activate And Deactivate.mp4 8.98 MB
    0805.Worksheet Triggers - Activate And Deactivate.mp4 6.57 MB
    0806.Other Useful Worksheet Triggers.mp4 15.26 MB
    0807.Using Application Events.mp4 26.78 MB
    0901.Error Trapping the Easy Way.mp4 10.84 MB
    0902.Make The VBA Ignore Errors.mp4 6.99 MB
    0903.Interact With The User When An Error Occurs.mp4 7.89 MB
    0904.Making Use Of The ERR Object.mp4 7.97 MB
    0905.Debugging Techniques.mp4 15.13 MB
    0906.Using Breakpoints To Help Debug.mp4 10.65 MB
    0907.Setup And Use A Watch.mp4 9.24 MB
    0908.Speeding Up The VBA Tips.mp4 28.09 MB
    1001.Using MSGBOX To Interact With Users.mp4 15.9 MB
    1002.Use INPUTBOX For Accepting Values From Users.mp4 12.01 MB
    1003.Selecting A Range With The INPUT Box.mp4 5.63 MB
    1004.An Introduction To UserForms.mp4 7.32 MB
    1005.Creating A UserForm.mp4 8.77 MB
    1006.Using Command Buttons.mp4 9.37 MB
    1007.Adding Option Buttons In A Frame.mp4 13.46 MB
    1008.Adding The Code That Makes The Form Work.mp4 17.1 MB
    1009.Calling Your UserForm And Validating Content.mp4 22.26 MB
    1010.UserForm Controls - The CheckBox.mp4 16.92 MB
    1012.Images On UserForms.mp4 11.79 MB
    1013.Labels And Text Boxes.mp4 10.82 MB
    1014.Multiple Tabs On A UserForm.mp4 17.28 MB
    1015.Allowing The User To Highlight A Range.mp4 7.83 MB
    1016.Scrollbar And Spin Controls.mp4 18.13 MB
    1017.Controlling Tab Order And Aligning Controls.mp4 19.55 MB
    1101.Trigger A Procedure From The Quick Access Toolbar.mp4 14.12 MB
    1102.Customizing The Ribbons.mp4 16.71 MB
    1103.Adding Buttons To Sheets.mp4 8.79 MB
    1104.Adding A Keyboard Shortcut Trigger.mp4 5.95 MB
    1105.Where To Store Your VBA Code.mp4 18.46 MB
    1106.Adding Code To The PERSONAL File.mp4 15.83 MB
    1201.So What's Next.mp4 2.79 MB

Download Info

  • Tips

    “InfiniteSkills - Learning Visual Basic for Microsoft Excel” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.