InfiniteSkills - Learning Visual Basic for Microsoft Excel

File Name

Size

Working Files/Chapter 1/sampleMacro.xlsm

18 kB

Working Files/Chapter 10/checkBox.xlsm

14 kB

Working Files/Chapter 10/formTemplate.xlsm

14 kB

Working Files/Chapter 10/formTemplate_Complete.xlsm

15 kB

Working Files/Chapter 10/formTemplate_Complete_withAlignmentDone.xlsm

17 kB

Working Files/Chapter 10/InputBox.xlsm

8.2 kB

Working Files/Chapter 10/InputBox_result.xlsm

14 kB

Working Files/Chapter 10/labelsandtextBoxes.xlsm

14 kB

Working Files/Chapter 10/listboxComboBox.xlsm

15 kB

Working Files/Chapter 10/msgBox.xlsm

8.2 kB

Working Files/Chapter 10/msgBox_result.xlsm

15 kB

Working Files/Chapter 10/multipleTabs.xlsm

17 kB

Working Files/Chapter 10/rangeSelect_result.xlsm

14 kB

Working Files/Chapter 10/refEdit.xlsm

18 kB

Working Files/Chapter 10/scrollbarandSpinControls.xlsm

15 kB

Working Files/Chapter 10/userFormExample.xlsm

20 kB

Working Files/Chapter 10/userFormStage2.xlsm

15 kB

Working Files/Chapter 10/userFormStage3.xlsm

16 kB

Working Files/Chapter 10/userFormStage4.xlsm

17 kB

Working Files/Chapter 10/userFormStage4_result.xlsm

43 kB

Working Files/Chapter 10/userFormStart.xlsm

13 kB

Working Files/Chapter 10/userformwithImages.xlsm

186 kB

Working Files/Chapter 11/changeCaseProcedure.xlsm

19 kB

Working Files/Chapter 2/myfirstMacro.xlsm

19 kB

Working Files/Chapter 3/degreesFunction.xlsm

14 kB

Working Files/Chapter 3/degreesFunction_Result.xlsm

15 kB

Working Files/Chapter 3/sample_Sub.xlsm

18 kB

Working Files/Chapter 4/constants.xlsm

13 kB

Working Files/Chapter 4/exampleScoping.xlsm

13 kB

Working Files/Chapter 4/exampleScoping_Result.xlsm

13 kB

Working Files/Chapter 4/exampleVariables.xlsm

13 kB

Working Files/Chapter 4/exampleVariables_Result.xlsm

13 kB

Working Files/Chapter 4/operators.xlsm

12 kB

Working Files/Chapter 4/staticVariable.xlsm

13 kB

Working Files/Chapter 4/stringanddateExpanded_Result.xlsm

15 kB

Working Files/Chapter 4/vba_DataTypes.pdf

268 kB

Working Files/Chapter 5/colorAndFont.xlsm

15 kB

Working Files/Chapter 5/colorAndFont_result.xlsm

16 kB

Working Files/Chapter 5/formulas.xlsm

13 kB

Working Files/Chapter 5/formulas_Result.xlsm

15 kB

Working Files/Chapter 5/methods.xlsm

13 kB

Working Files/Chapter 5/methods_Result.xlsm

16 kB

Working Files/Chapter 5/numberFormats.xlsm

8.8 kB

Working Files/Chapter 5/numberFormats_result.xlsm

16 kB

Working Files/Chapter 5/RangeObject.xlsm

13 kB

Working Files/Chapter 5/rangeTesting.xlsm

13 kB

Working Files/Chapter 5/readonlyProperties_results.xlsm

15 kB

Working Files/Chapter 5/textProperty.xlsm

14 kB

Working Files/Chapter 6/excelFunctions.xlsm

13 kB

Working Files/Chapter 6/excelFunctions_Result.xlsm

15 kB

Working Files/Chapter 6/sample.xlsm

16 kB

Working Files/Chapter 7/caseSelect.xlsm

14 kB

Working Files/Chapter 7/caseSelect_Result.xlsm

14 kB

Working Files/Chapter 7/doWHile_Result.xlsm

14 kB

Working Files/Chapter 7/foreachCollection.xlsm

12 kB

Working Files/Chapter 7/foreachCollection_Result.xlsm

15 kB

Working Files/Chapter 7/forNext.xlsm

8.2 kB

Working Files/Chapter 7/forNext_Result.xlsm

15 kB

Working Files/Chapter 7/IF.xlsm

14 kB

Working Files/Chapter 7/IF_ESLEIF_Result.xlsm

14 kB

Working Files/Chapter 7/IF_result.xlsm

14 kB

Working Files/Chapter 7/If_Then_Else.xlsm

14 kB

Working Files/Chapter 8/keyPress.xlsm

16 kB

Working Files/Chapter 8/keyPressResult.xlsm

16 kB

Working Files/Chapter 8/OpenCloseEvent.xlsm

9.2 kB

Working Files/Chapter 8/OpenCloseEvent_CloseTrigger.xlsm

16 kB

Working Files/Chapter 8/OpenCloseEvent_OpenTrigger.xlsm

16 kB

Working Files/Chapter 8/OpenCloseEvent_OpenTrigger_test.xlsm

16 kB

Working Files/Chapter 8/speakingSheet.xlsm

15 kB

Working Files/Chapter 8/WorkBookEvents.xlsm

9.8 kB

Working Files/Chapter 8/WorkBookEvents_SheetActivateandDeactivate.xlsm

16 kB

Working Files/Chapter 8/worksheetActivate.xlsm

10 kB

Working Files/Chapter 8/worksheetActivate_result.xlsm

16 kB

Working Files/Chapter 8/worksheetTriggers.xlsm

15 kB

Working Files/Chapter 8/worksheetTriggers_result.xlsm

17 kB

Working Files/Chapter 9/breakpoints.xlsm

15 kB

Working Files/Chapter 9/breakpoints_Result.xlsm

15 kB

Working Files/Chapter 9/debugOutput.xlsm

14 kB

Working Files/Chapter 9/debugOutput_Result.xlsm

15 kB

Working Files/Chapter 9/errorTrap.xlsm

14 kB

Working Files/Chapter 9/errorTrap_Result.xlsm

14 kB

Working Files/Chapter 9/errorTrapError.xlsm

14 kB

Working Files/Chapter 9/errorTrapError_result.xlsm

15 kB

Working Files/Chapter 9/errorTrapResume.xlsm

14 kB

Working Files/Chapter 9/errorTrapResume_Result.xlsm

14 kB

Working Files/Chapter 9/errorTrapResumeLabel.xlsm

14 kB

Working Files/Chapter 9/errorTrapResumeLabel_result.xlsm

15 kB

Working Files/Chapter 9/errorTrapResumeWithLabel.xlsm

14 kB

Working Files/Chapter 9/errorTrapResumeWithLabel_result.xlsm

15 kB

Working Files/Chapter 9/sampleworkbook.xlsx

8.3 kB

Working Files/Chapter 9/speedTips.xlsm

16 kB

Working Files/Chapter 9/speedTips.xlsx

8.1 kB

Working Files/Chapter 9/speedTips_Result.xlsm

58 kB

Working Files/Chapter 9/watches.xlsm

15 kB

Working Files/Chapter 9/watches_result.xlsm

15 kB

0101.What Will I Get Out Of This Course.mp4

16 MB

0102.About The Author.mp4

2.2 MB

0103.The Working Files Explained.mp4

5.9 MB

0104.What Is VBA.mp4

5.4 MB

0105.Excel 2010 Security Settings And Macro Files.mp4

14 MB

0106.The Developer Ribbon.mp4

8.3 MB

0201.Recording And Running A Simple Macro.mp4

19 MB

0202.Editing An Existing Macro In The Visual Basic Editor.mp4

11 MB

0203.The New Macro Enabled File Type.mp4

8.2 MB

0204.Quick Tour Of The Visual Basic Editor.mp4

10 MB

0205.Watch A Macro Write Your VBA.mp4

9.3 MB

0301.What Is A Module.mp4

7.2 MB

0302.Creating A Sub Procedure Manually.mp4

5.0 MB

0303.How To Call A Sub Procedure.mp4

6.0 MB

0304.Creating A Function Procedure.mp4

4.0 MB

0305.How To Call A Function.mp4

5.7 MB

0401.Using Comments Within Your VBA Code.mp4

7.6 MB

0402.Declaring Variables And Data Types.mp4

13 MB

0403.The Scope Of A Variable.mp4

8.2 MB

0404.The Static Declaration And Variable Expiry.mp4

11 MB

0405.Constants Instead Of Variables.mp4

5.3 MB

0406.An Intrinsic Constant.mp4

6.8 MB

0407.String And Date Types Expanded.mp4

8.8 MB

0408.VBA Operators.mp4

14 MB

0409.Arrays.mp4

7.0 MB

0410.Multi-Dimensional Arrays.mp4

4.6 MB

0411.Dynamic Arrays.mp4

5.3 MB

0501.Referencing Cells Using The Range Object.mp4

6.4 MB

0502.The CELLS Property.mp4

3.8 MB

0503.The OFFSET Property.mp4

3.3 MB

0504.The VALUE Of Ranges.mp4

18 MB

0505.The TEXT Object Of The RANGE.mp4

8.3 MB

0506.A Number Of Read Only RANGE Properties.mp4

14 MB

0507.The FONT Property And Colors.mp4

12 MB

0508.Formatting Numeric Values.mp4

6.5 MB

0509.Add Formulas To Cells Through VBA Code.mp4

10 MB

0510.Common METHODS Of The RANGE Object.mp4

19 MB

0601.What Is A Function.mp4

2.1 MB

0602.Built In VBA Date Functions.mp4

4.1 MB

0603.Text Manipulation With VBA Functions.mp4

12 MB

0604.Determining File Sizes Using FILELEN.mp4

6.1 MB

0605.Using Worksheet Excel Functions In VBA Code.mp4

13 MB

0606.User Defined Functions.mp4

7.2 MB

0701.Using GOTO And Labels.mp4

5.9 MB

0702.Controlling The Program Flow With IF THEN ELSE.mp4

6.1 MB

0703.Multiple Criteria Plus Nested IFs.mp4

8.2 MB

0704.Adding ELSEIF To Speed Up Execution.mp4

5.9 MB

0705.SELECT CASE As An Alternative To IF.mp4

10 MB

0706.The FOR NEXT Loop.mp4

13 MB

0707.FOR NEXT With A VBA Collection.mp4

16 MB

0708.DO WHILE Loop.mp4

9.1 MB

0801.How To Create An Event.mp4

12 MB

0802.WorkBook Events - Open.mp4

17 MB

0803.Workbook Events - Closing And Saving.mp4

18 MB

0804.Workbook Triggers - Activate And Deactivate.mp4

9.0 MB

0805.Worksheet Triggers - Activate And Deactivate.mp4

6.6 MB

0806.Other Useful Worksheet Triggers.mp4

15 MB

0807.Using Application Events.mp4

27 MB

0901.Error Trapping the Easy Way.mp4

11 MB

0902.Make The VBA Ignore Errors.mp4

7.0 MB

0903.Interact With The User When An Error Occurs.mp4

7.9 MB

0904.Making Use Of The ERR Object.mp4

8.0 MB

0905.Debugging Techniques.mp4

15 MB

0906.Using Breakpoints To Help Debug.mp4

11 MB

0907.Setup And Use A Watch.mp4

9.2 MB

0908.Speeding Up The VBA Tips.mp4

28 MB

1001.Using MSGBOX To Interact With Users.mp4

16 MB

1002.Use INPUTBOX For Accepting Values From Users.mp4

12 MB

1003.Selecting A Range With The INPUT Box.mp4

5.6 MB

1004.An Introduction To UserForms.mp4

7.3 MB

1005.Creating A UserForm.mp4

8.8 MB

1006.Using Command Buttons.mp4

9.4 MB

1007.Adding Option Buttons In A Frame.mp4

14 MB

1008.Adding The Code That Makes The Form Work.mp4

17 MB

1009.Calling Your UserForm And Validating Content.mp4

22 MB

1010.UserForm Controls - The CheckBox.mp4

17 MB

1012.Images On UserForms.mp4

12 MB

1013.Labels And Text Boxes.mp4

11 MB

1014.Multiple Tabs On A UserForm.mp4

17 MB

1015.Allowing The User To Highlight A Range.mp4

7.8 MB

1016.Scrollbar And Spin Controls.mp4

18 MB

1017.Controlling Tab Order And Aligning Controls.mp4

20 MB

1101.Trigger A Procedure From The Quick Access Toolbar.mp4

14 MB

1102.Customizing The Ribbons.mp4

17 MB

1103.Adding Buttons To Sheets.mp4

8.8 MB

1104.Adding A Keyboard Shortcut Trigger.mp4

6.0 MB

1105.Where To Store Your VBA Code.mp4

18 MB

1106.Adding Code To The PERSONAL File.mp4

16 MB

1201.So What's Next.mp4

2.8 MB