InfiniteSkills - Learning Visual Basic for Microsoft Excel

1. 0101.What Will I Get Out Of This Course.mp415.76MB
2. 0102.About The Author.mp42.21MB
3. 0103.The Working Files Explained.mp45.89MB
4. 0104.What Is VBA.mp45.36MB
5. 0105.Excel 2010 Security Settings And Macro Files.mp414.43MB
6. 0106.The Developer Ribbon.mp48.34MB
7. 0201.Recording And Running A Simple Macro.mp419.29MB
8. 0202.Editing An Existing Macro In The Visual Basic Editor.mp410.78MB
9. 0203.The New Macro Enabled File Type.mp48.19MB
10. 0204.Quick Tour Of The Visual Basic Editor.mp410.49MB
11. 0205.Watch A Macro Write Your VBA.mp49.3MB
12. 0301.What Is A Module.mp47.17MB
13. 0302.Creating A Sub Procedure Manually.mp44.96MB
14. 0303.How To Call A Sub Procedure.mp46.02MB
15. 0304.Creating A Function Procedure.mp44.05MB
16. 0305.How To Call A Function.mp45.71MB
17. 0401.Using Comments Within Your VBA Code.mp47.57MB
18. 0402.Declaring Variables And Data Types.mp413.08MB
19. 0403.The Scope Of A Variable.mp48.21MB
20. 0404.The Static Declaration And Variable Expiry.mp410.64MB
21. 0405.Constants Instead Of Variables.mp45.33MB
22. 0406.An Intrinsic Constant.mp46.77MB
23. 0407.String And Date Types Expanded.mp48.84MB
24. 0408.VBA Operators.mp413.63MB
25. 0409.Arrays.mp47.04MB
26. 0410.Multi-Dimensional Arrays.mp44.59MB
27. 0411.Dynamic Arrays.mp45.26MB
28. 0501.Referencing Cells Using The Range Object.mp46.4MB
29. 0502.The CELLS Property.mp43.85MB
30. 0503.The OFFSET Property.mp43.34MB
31. 0504.The VALUE Of Ranges.mp418.21MB
32. 0505.The TEXT Object Of The RANGE.mp48.29MB
33. 0506.A Number Of Read Only RANGE Properties.mp413.95MB
34. 0507.The FONT Property And Colors.mp412.35MB
35. 0508.Formatting Numeric Values.mp46.47MB
36. 0509.Add Formulas To Cells Through VBA Code.mp410.22MB
37. 0510.Common METHODS Of The RANGE Object.mp419.39MB
38. 0601.What Is A Function.mp42.14MB
39. 0602.Built In VBA Date Functions.mp44.06MB
40. 0603.Text Manipulation With VBA Functions.mp412.22MB
41. 0604.Determining File Sizes Using FILELEN.mp46.15MB
42. 0605.Using Worksheet Excel Functions In VBA Code.mp413.33MB
43. 0606.User Defined Functions.mp47.16MB
44. 0701.Using GOTO And Labels.mp45.92MB
45. 0702.Controlling The Program Flow With IF THEN ELSE.mp46.09MB
46. 0703.Multiple Criteria Plus Nested IFs.mp48.23MB
47. 0704.Adding ELSEIF To Speed Up Execution.mp45.93MB
48. 0705.SELECT CASE As An Alternative To IF.mp410.01MB
49. 0706.The FOR NEXT Loop.mp413.27MB
50. 0707.FOR NEXT With A VBA Collection.mp415.62MB
51. 0708.DO WHILE Loop.mp49.07MB
52. 0801.How To Create An Event.mp412.39MB
53. 0802.WorkBook Events - Open.mp416.68MB
54. 0803.Workbook Events - Closing And Saving.mp417.59MB
55. 0804.Workbook Triggers - Activate And Deactivate.mp48.98MB
56. 0805.Worksheet Triggers - Activate And Deactivate.mp46.57MB
57. 0806.Other Useful Worksheet Triggers.mp415.26MB
58. 0807.Using Application Events.mp426.78MB
59. 0901.Error Trapping the Easy Way.mp410.84MB
60. 0902.Make The VBA Ignore Errors.mp46.99MB
61. 0903.Interact With The User When An Error Occurs.mp47.89MB
62. 0904.Making Use Of The ERR Object.mp47.97MB
63. 0905.Debugging Techniques.mp415.13MB
64. 0906.Using Breakpoints To Help Debug.mp410.65MB
65. 0907.Setup And Use A Watch.mp49.24MB
66. 0908.Speeding Up The VBA Tips.mp428.09MB
67. 1001.Using MSGBOX To Interact With Users.mp415.9MB
68. 1002.Use INPUTBOX For Accepting Values From Users.mp412.01MB
69. 1003.Selecting A Range With The INPUT Box.mp45.63MB
70. 1004.An Introduction To UserForms.mp47.32MB
71. 1005.Creating A UserForm.mp48.77MB
72. 1006.Using Command Buttons.mp49.37MB
73. 1007.Adding Option Buttons In A Frame.mp413.46MB
74. 1008.Adding The Code That Makes The Form Work.mp417.1MB
75. 1009.Calling Your UserForm And Validating Content.mp422.26MB
76. 1010.UserForm Controls - The CheckBox.mp416.92MB
77. 1012.Images On UserForms.mp411.79MB
78. 1013.Labels And Text Boxes.mp410.82MB
79. 1014.Multiple Tabs On A UserForm.mp417.28MB
80. 1015.Allowing The User To Highlight A Range.mp47.83MB
81. 1016.Scrollbar And Spin Controls.mp418.13MB
82. 1017.Controlling Tab Order And Aligning Controls.mp419.55MB
83. 1101.Trigger A Procedure From The Quick Access Toolbar.mp414.12MB
84. 1102.Customizing The Ribbons.mp416.71MB
85. 1103.Adding Buttons To Sheets.mp48.79MB
86. 1104.Adding A Keyboard Shortcut Trigger.mp45.95MB
87. 1105.Where To Store Your VBA Code.mp418.46MB
88. 1106.Adding Code To The PERSONAL File.mp415.83MB
89. 1201.So What's Next.mp42.79MB