589689.xyz

[ ] Udemy - Excel VBA - The VBA Beginner's Blueprint to Programming Excel (updated 6 - 2021)

  • 收录时间:2022-02-04 11:56:57
  • 文件大小:1GB
  • 下载次数:1
  • 最近下载:2022-02-04 11:56:57
  • 磁力链接:
立即下载 复制链接

文件列表

  1. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/1. Variables.mp4 43MB
  2. ~Get Your Files Here !/14. More VBA/4. Using Static Arrays.mp4 35MB
  3. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/20. Filtering Fields.mp4 33MB
  4. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/7. Error Handling The On Error GoTo Statement.mp4 32MB
  5. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/6. The Cells Object.mp4 24MB
  6. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/19. Sorting Fields.mp4 23MB
  7. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/4. Exercise Input Boxes.mp4 21MB
  8. ~Get Your Files Here !/2. Introduction to Visual Basic for Applications/1. Writing Code vs. Recording Macros.mp4 20MB
  9. ~Get Your Files Here !/10. Looping Your VBA Code/10. Exercise Do Until Loops.mp4 20MB
  10. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/13. The Range.End Property.mp4 20MB
  11. ~Get Your Files Here !/10. Looping Your VBA Code/7. Exercise For Each, Example 2.mp4 19MB
  12. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/5. Debugging The Immediate Window.mp4 19MB
  13. ~Get Your Files Here !/5. Getting Started with Programming VBA/8. Comments.mp4 18MB
  14. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/2. Exercise Message Boxes.mp4 18MB
  15. ~Get Your Files Here !/2. Introduction to Visual Basic for Applications/2. Understanding Objects.mp4 18MB
  16. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/4. Recording in Relative Mode.mp4 17MB
  17. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/6. Scope.mp4 16MB
  18. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/4. The Code Window.mp4 16MB
  19. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/4. Debugging Stepping Through VBA Code.mp4 15MB
  20. ~Get Your Files Here !/12. Creating User Forms with VBA/4. Adding Controls to a Form.mp4 15MB
  21. ~Get Your Files Here !/14. More VBA/7. Deleting Blank Rows and Columns.mp4 15MB
  22. ~Get Your Files Here !/12. Creating User Forms with VBA/5. Attaching Events to Form Controls.mp4 14MB
  23. ~Get Your Files Here !/10. Looping Your VBA Code/1. Introduction to Loops.mp4 14MB
  24. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/2. Debugging Setting a Breakpoint.mp4 14MB
  25. ~Get Your Files Here !/10. Looping Your VBA Code/9. Do Until Loop.mp4 14MB
  26. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/2. If...Then.mp4 13MB
  27. ~Get Your Files Here !/10. Looping Your VBA Code/12. Exercise Do While Loop.mp4 12MB
  28. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/4. Select Case.mp4 12MB
  29. ~Get Your Files Here !/2. Introduction to Visual Basic for Applications/4. How VBA Refers to Objects.mp4 12MB
  30. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/9. Error Handling The Err Object.mp4 11MB
  31. ~Get Your Files Here !/12. Creating User Forms with VBA/2. Creating a Form.mp4 11MB
  32. ~Get Your Files Here !/10. Looping Your VBA Code/11. Do While Loop.mp4 11MB
  33. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/16. Using PasteSpecial.mp4 10MB
  34. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/5. Modifying Macros Using VBA.mp4 10MB
  35. ~Get Your Files Here !/14. More VBA/8. Using GoTo to Create Branching Logic in Your VBA Code.mp4 10MB
  36. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/1. Creating a New Workbook.mp4 10MB
  37. ~Get Your Files Here !/14. More VBA/1. Creating Functions for Your Worksheets.mp4 10MB
  38. ~Get Your Files Here !/14. More VBA/2. Creating a Simple Chart with VBA.mp4 10MB
  39. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/3. Debugging The Watch Window.mp4 10MB
  40. ~Get Your Files Here !/5. Getting Started with Programming VBA/9. Using Objects.mp4 9MB
  41. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/1. Recording Macros.mp4 9MB
  42. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/8. ActiveCell.mp4 9MB
  43. ~Get Your Files Here !/16. Thank You!/1. Thank You!.mp4 9MB
  44. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/14. Copying Data on Your Worksheet.mp4 9MB
  45. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/4. Adding Worksheets.mp4 8MB
  46. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/6. Macro Example Creating Buttons to Navigate Between Worksheets.mp4 8MB
  47. ~Get Your Files Here !/10. Looping Your VBA Code/3. Exercise For Next Loop.mp4 8MB
  48. ~Get Your Files Here !/12. Creating User Forms with VBA/8. Test Your Skills.mp4 8MB
  49. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/3. If...Then...Else.mp4 8MB
  50. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/1. Introduction to Decision Structures.mp4 8MB
  51. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/2. The Project Explorer.mp4 8MB
  52. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/3. The Properties Window.mp4 8MB
  53. ~Get Your Files Here !/10. Looping Your VBA Code/6. Exercise For Each, Example 1.mp4 8MB
  54. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/6. Debugging The Locals Window.mp4 8MB
  55. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/12. The CurrentRegion Property.mp4 8MB
  56. ~Get Your Files Here !/2. Introduction to Visual Basic for Applications/3. Containers & Collections.mp4 8MB
  57. ~Get Your Files Here !/5. Getting Started with Programming VBA/10. Using Methods.mp4 8MB
  58. ~Get Your Files Here !/10. Looping Your VBA Code/13. Exiting a Do Loop.mp4 8MB
  59. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/15. The Paste Method.mp4 8MB
  60. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/1. The Microsoft Visual Basic Editor.mp4 7MB
  61. ~Get Your Files Here !/8. Formatting Values with Functions/1. The Format Function Using Named Format Expressions.mp4 7MB
  62. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/2. Testing the Macro and Looking at the VBA.mp4 7MB
  63. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/21. Removing Duplicate Records.mp4 7MB
  64. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/17. Clearing Contents and Formats.mp4 7MB
  65. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/6. Adding and Removing Modules.mp4 7MB
  66. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/1. Working with Message Boxes.mp4 7MB
  67. ~Get Your Files Here !/8. Formatting Values with Functions/2. Using the FormatCurrency Function.mp4 7MB
  68. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/2. Opening and Closing Workbooks.mp4 7MB
  69. ~Get Your Files Here !/14. More VBA/3. Using WorksheetFunction to Perform Calculations.mp4 7MB
  70. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/5. Other Windows the Immediate Window, the Locals Window, and the Watch Window.mp4 6MB
  71. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/5. Copying Worksheets.mp4 6MB
  72. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/7. Naming Modules.mp4 6MB
  73. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/8. Error Handling The On Error Resume Next Statement.mp4 6MB
  74. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/1. Introduction to Debugging and Error Handling.mp4 6MB
  75. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/3. Worksheets vs. Sheets.mp4 6MB
  76. ~Get Your Files Here !/14. More VBA/6. Using VBA to E-mail Workbooks.mp4 6MB
  77. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/3. Working with Input Boxes.mp4 5MB
  78. ~Get Your Files Here !/5. Getting Started with Programming VBA/3. Resetting Your VBA Code Upon Errors.mp4 5MB
  79. ~Get Your Files Here !/5. Getting Started with Programming VBA/11. Using Event Procedures - UPDATED.mp4 5MB
  80. ~Get Your Files Here !/5. Getting Started with Programming VBA/5. Calling a Sub Procedure.mp4 5MB
  81. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/4. Declaring Constants.mp4 5MB
  82. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/5. Carriage Return Line Feed.mp4 5MB
  83. ~Get Your Files Here !/5. Getting Started with Programming VBA/1. Introduction to Writing VBA.mp4 5MB
  84. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/11. Referring to Named Ranges.mp4 5MB
  85. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/8. Customizing the Visual Basic Environment.mp4 5MB
  86. ~Get Your Files Here !/10. Looping Your VBA Code/2. For Next Loop.mp4 5MB
  87. ~Get Your Files Here !/10. Looping Your VBA Code/8. Exiting a For Loop.mp4 5MB
  88. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/3. Absolute vs. Relative Mode.mp4 5MB
  89. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/7. Exercise Using Operators and the Cells Object.mp4 5MB
  90. ~Get Your Files Here !/12. Creating User Forms with VBA/6. Validating Form Data.mp4 4MB
  91. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/18. Exercise Using Name, and Value.mp4 4MB
  92. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/9. Rows and Columns.mp4 4MB
  93. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/2. Object Variables.mp4 4MB
  94. ~Get Your Files Here !/12. Creating User Forms with VBA/1. Introduction to User Forms.mp4 4MB
  95. ~Get Your Files Here !/5. Getting Started with Programming VBA/6. Structure of Functions.mp4 4MB
  96. ~Get Your Files Here !/5. Getting Started with Programming VBA/2. A Few Time Savers Writing VBA.mp4 4MB
  97. ~Get Your Files Here !/1. Welcome to Excel VBA/1. Introduction.mp4 3MB
  98. ~Get Your Files Here !/12. Creating User Forms with VBA/3. Showing a Form from the VBE.mp4 3MB
  99. ~Get Your Files Here !/14. More VBA/5. The Array Function.mp4 3MB
  100. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/3. Data Types.mp4 3MB
  101. ~Get Your Files Here !/10. Looping Your VBA Code/4. Stepping.mp4 3MB
  102. ~Get Your Files Here !/5. Getting Started with Programming VBA/7. Calling a Function.mp4 2MB
  103. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/10. The Range Object.mp4 2MB
  104. ~Get Your Files Here !/12. Creating User Forms with VBA/7. Exercise Dependent Combo Boxes.mp4 2MB
  105. ~Get Your Files Here !/10. Looping Your VBA Code/5. For Each.mp4 2MB
  106. ~Get Your Files Here !/5. Getting Started with Programming VBA/4. Structure of Sub Procedures.mp4 1MB
  107. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/Customizing-the-Visual-Basic-Environment.pdf 606KB
  108. ~Get Your Files Here !/12. Creating User Forms with VBA/Form-Project.pdf 530KB
  109. ~Get Your Files Here !/10. Looping Your VBA Code/Test-Your-Skills-Loops.pdf 527KB
  110. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Test-Your-Skills.pdf 522KB
  111. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/Exporting-and-Importing-Modules.pdf 490KB
  112. ~Get Your Files Here !/14. More VBA/Code-Snippets.pdf 467KB
  113. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/Test-Your-Skills-User-Interaction.pdf 452KB
  114. ~Get Your Files Here !/8. Formatting Values with Functions/Custom-String-Formatting.pdf 446KB
  115. ~Get Your Files Here !/15. Excel VBA References/VBA-Keyboard-Shortcuts.pdf 433KB
  116. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/Message-Box-Buttons.pdf 423KB
  117. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/XlAutoFilterOperator.pdf 422KB
  118. ~Get Your Files Here !/12. Creating User Forms with VBA/Dependent-Combo-Boxes.pdf 419KB
  119. ~Get Your Files Here !/15. Excel VBA References/Excel-VBA-Functions.pdf 412KB
  120. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/Accessing-Macros-through-the-Quick-Access-Toolbar.pdf 410KB
  121. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Useful-Font-Object-Members.pdf 400KB
  122. ~Get Your Files Here !/12. Creating User Forms with VBA/Suggested-Naming-Conventions-for-Controls.pdf 397KB
  123. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/Identifier-Type-Characters.pdf 392KB
  124. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Using-the-Cells-Object-and-Operators.pdf 392KB
  125. ~Get Your Files Here !/15. Excel VBA References/Common-Excel-VBA-Statements.pdf 390KB
  126. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/Protecting-Code.pdf 383KB
  127. ~Get Your Files Here !/8. Formatting Values with Functions/Custom-Number-Formatting.pdf 383KB
  128. ~Get Your Files Here !/15. Excel VBA References/Glossary.pdf 380KB
  129. ~Get Your Files Here !/14. More VBA/xlCellTypes-You-Can-Use-with-the-SpecialCells-Method.pdf 376KB
  130. ~Get Your Files Here !/8. Formatting Values with Functions/Custom-Date-Formatting.pdf 375KB
  131. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/The-Sort-Method.pdf 374KB
  132. ~Get Your Files Here !/12. Creating User Forms with VBA/Form-Controls.pdf 373KB
  133. ~Get Your Files Here !/15. Excel VBA References/Reserved-Keywords.pdf 371KB
  134. ~Get Your Files Here !/5. Getting Started with Programming VBA/Workbook-Events.pdf 370KB
  135. ~Get Your Files Here !/2. Introduction to Visual Basic for Applications/Security-Settings.pdf 369KB
  136. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/Using-Byte-Variables.pdf 367KB
  137. ~Get Your Files Here !/8. Formatting Values with Functions/The-Format-Function-Using-Named-Format-Expressions.pdf 366KB
  138. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/VBA-Datatypes.pdf 362KB
  139. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/Accessing-Macros-through-the-Ribbon.pdf 362KB
  140. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/Accessing-Macros-through-Command-Buttons.pdf 357KB
  141. ~Get Your Files Here !/5. Getting Started with Programming VBA/Worksheet-Events.pdf 357KB
  142. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/Keyboard-Shortcuts-for-the-VBA-Code-Window.pdf 352KB
  143. ~Get Your Files Here !/8. Formatting Values with Functions/FormatDateTime-Function.pdf 350KB
  144. ~Get Your Files Here !/12. Creating User Forms with VBA/Aligning-Controls.pdf 348KB
  145. ~Get Your Files Here !/12. Creating User Forms with VBA/Form-Events.pdf 345KB
  146. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/Accessing-Macros-through-Shapes.pdf 344KB
  147. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/Docking-Windows.pdf 342KB
  148. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/Using-Currency-Variables.pdf 339KB
  149. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/Using-Date-Variables.pdf 335KB
  150. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/Using-String-Variables.pdf 334KB
  151. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/The-Range-Object.pdf 331KB
  152. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/Logical-Operators.pdf 329KB
  153. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Using-Rows-and-Columns.pdf 329KB
  154. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/Arithmetic-Operators.pdf 327KB
  155. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/Message-Box-Exercise.pdf 319KB
  156. ~Get Your Files Here !/10. Looping Your VBA Code/For-Next-Loop-Exercise.pdf 304KB
  157. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/Input-Box-Exercise.pdf 301KB
  158. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/Searching-for-Text-Your-Code.pdf 288KB
  159. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/Assigning-a-Macros-to-a-Shortcut-Key.pdf 280KB
  160. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/The-Object-Browser.pdf 273KB
  161. ~Get Your Files Here !/15. Excel VBA References/Unreserved-Keywords.pdf 254KB
  162. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/Formatting.xlsm 253KB
  163. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/Tracing-Code-Execution.pdf 248KB
  164. ~Get Your Files Here !/14. More VBA/Creating-Functions-Exercise.pdf 240KB
  165. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Sorting.xlsm 164KB
  166. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Filtering.xlsm 156KB
  167. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Selecting.xlsm 155KB
  168. ~Get Your Files Here !/14. More VBA/DeletingBlankRowsandColumns.xlsm 152KB
  169. ~Get Your Files Here !/10. Looping Your VBA Code/How-are-you-enjoying-the-Course.pdf 26KB
  170. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/Select-Case.xlsm 19KB
  171. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/InputBox.xlsm 19KB
  172. ~Get Your Files Here !/10. Looping Your VBA Code/DoWhile.xlsm 19KB
  173. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/Debugging.xlsm 19KB
  174. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/ErrorHandling.xlsm 19KB
  175. ~Get Your Files Here !/14. More VBA/Creating-Functions.xlsm 19KB
  176. ~Get Your Files Here !/10. Looping Your VBA Code/xExitDo.xlsm 18KB
  177. ~Get Your Files Here !/10. Looping Your VBA Code/For-Each.xlsm 18KB
  178. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/CurrentRegion.xlsm 18KB
  179. ~Get Your Files Here !/10. Looping Your VBA Code/DoUntil.xlsm 18KB
  180. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Exercise-Name-Value.xlsm 17KB
  181. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/PasteSpecial.xlsm 17KB
  182. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/CopyData.xlsm 17KB
  183. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Clear.xlsm 16KB
  184. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/Message-Box.xlsm 16KB
  185. ~Get Your Files Here !/14. More VBA/Static-Arrays.xlsm 16KB
  186. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/RemoveDuplicates.xlsm 15KB
  187. ~Get Your Files Here !/14. More VBA/Create-Charts.xlsm 15KB
  188. ~Get Your Files Here !/10. Looping Your VBA Code/For-Loop-Exercise.xlsm 15KB
  189. ~Get Your Files Here !/14. More VBA/ArraytoPopulate.xlsm 14KB
  190. ~Get Your Files Here !/14. More VBA/GoTo.xlsm 13KB
  191. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/IfThen.xlsm 13KB
  192. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Add.xlsm 13KB
  193. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/Scope.xlsm 13KB
  194. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/4. Exercise Input Boxes-en_US.srt 10KB
  195. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/1. Variables-en_US.srt 10KB
  196. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/20. Filtering Fields-en_US.srt 9KB
  197. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Copy.xlsm 9KB
  198. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/The-Cells-Object-and-Operators.xlsx 9KB
  199. ~Get Your Files Here !/10. Looping Your VBA Code/10. Exercise Do Until Loops-en_US.srt 8KB
  200. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/2. Exercise Message Boxes-en_US.srt 8KB
  201. ~Get Your Files Here !/10. Looping Your VBA Code/7. Exercise For Each, Example 2-en_US.srt 8KB
  202. ~Get Your Files Here !/14. More VBA/1. Creating Functions for Your Worksheets-en_US.srt 8KB
  203. ~Get Your Files Here !/14. More VBA/4. Using Static Arrays-en_US.srt 8KB
  204. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/4. Recording in Relative Mode-en_US.srt 8KB
  205. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/5. Debugging The Immediate Window-en_US.srt 8KB
  206. ~Get Your Files Here !/12. Creating User Forms with VBA/5. Attaching Events to Form Controls-en_US.srt 8KB
  207. ~Get Your Files Here !/5. Getting Started with Programming VBA/8. Comments-en_US.srt 7KB
  208. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/7. Error Handling The On Error GoTo Statement-en_US.srt 7KB
  209. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/6. Scope-en_US.srt 7KB
  210. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/4. Debugging Stepping Through VBA Code-en_US.srt 6KB
  211. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/4. The Code Window-en_US.srt 6KB
  212. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/1. Recording Macros-en_US.srt 6KB
  213. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/1. Working with Message Boxes-en_US.srt 6KB
  214. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/4. Select Case-en_US.srt 6KB
  215. ~Get Your Files Here !/14. More VBA/8. Using GoTo to Create Branching Logic in Your VBA Code-en_US.srt 6KB
  216. ~Get Your Files Here !/10. Looping Your VBA Code/3. Exercise For Next Loop-en_US.srt 6KB
  217. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/2. Debugging Setting a Breakpoint-en_US.srt 6KB
  218. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/4. Adding Worksheets-en_US.srt 5KB
  219. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/13. The Range.End Property-en_US.srt 5KB
  220. ~Get Your Files Here !/14. More VBA/3. Using WorksheetFunction to Perform Calculations-en_US.srt 5KB
  221. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/8. ActiveCell-en_US.srt 5KB
  222. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/15. The Paste Method-en_US.srt 5KB
  223. ~Get Your Files Here !/17. Course Coupons/[BONUS LECTURE] Course Coupons Learn New Skills.html 5KB
  224. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/2. If...Then-en_US.srt 5KB
  225. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/5. Modifying Macros Using VBA-en_US.srt 5KB
  226. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/9. Error Handling The Err Object-en_US.srt 5KB
  227. ~Get Your Files Here !/14. More VBA/2. Creating a Simple Chart with VBA-en_US.srt 5KB
  228. ~Get Your Files Here !/14. More VBA/7. Deleting Blank Rows and Columns-en_US.srt 5KB
  229. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/21. Removing Duplicate Records-en_US.srt 5KB
  230. ~Get Your Files Here !/10. Looping Your VBA Code/2. For Next Loop-en_US.srt 5KB
  231. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/6. Macro Example Creating Buttons to Navigate Between Worksheets-en_US.srt 5KB
  232. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/19. Sorting Fields-en_US.srt 5KB
  233. ~Get Your Files Here !/5. Getting Started with Programming VBA/2. A Few Time Savers Writing VBA-en_US.srt 5KB
  234. ~Get Your Files Here !/8. Formatting Values with Functions/2. Using the FormatCurrency Function-en_US.srt 5KB
  235. ~Get Your Files Here !/12. Creating User Forms with VBA/4. Adding Controls to a Form-en_US.srt 5KB
  236. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/17. Clearing Contents and Formats-en_US.srt 4KB
  237. ~Get Your Files Here !/5. Getting Started with Programming VBA/10. Using Methods-en_US.srt 4KB
  238. ~Get Your Files Here !/5. Getting Started with Programming VBA/5. Calling a Sub Procedure-en_US.srt 4KB
  239. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/14. Copying Data on Your Worksheet-en_US.srt 4KB
  240. ~Get Your Files Here !/10. Looping Your VBA Code/12. Exercise Do While Loop-en_US.srt 4KB
  241. ~Get Your Files Here !/8. Formatting Values with Functions/1. The Format Function Using Named Format Expressions-en_US.srt 4KB
  242. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/1. Creating a New Workbook-en_US.srt 4KB
  243. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/3. Working with Input Boxes-en_US.srt 4KB
  244. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/16. Using PasteSpecial-en_US.srt 4KB
  245. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/2. Testing the Macro and Looking at the VBA-en_US.srt 4KB
  246. ~Get Your Files Here !/5. Getting Started with Programming VBA/6. Structure of Functions-en_US.srt 4KB
  247. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/6. Debugging The Locals Window-en_US.srt 4KB
  248. ~Get Your Files Here !/10. Looping Your VBA Code/6. Exercise For Each, Example 1-en_US.srt 4KB
  249. ~Get Your Files Here !/5. Getting Started with Programming VBA/11. Using Event Procedures - UPDATED-en_US.srt 4KB
  250. ~Get Your Files Here !/14. More VBA/6. Using VBA to E-mail Workbooks-en_US.srt 4KB
  251. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/5. Copying Worksheets-en_US.srt 4KB
  252. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/3. Debugging The Watch Window-en_US.srt 4KB
  253. ~Get Your Files Here !/5. Getting Started with Programming VBA/9. Using Objects-en_US.srt 4KB
  254. ~Get Your Files Here !/12. Creating User Forms with VBA/2. Creating a Form-en_US.srt 3KB
  255. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/2. Object Variables-en_US.srt 3KB
  256. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/4. Declaring Constants-en_US.srt 3KB
  257. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/1. The Microsoft Visual Basic Editor-en_US.srt 3KB
  258. ~Get Your Files Here !/2. Introduction to Visual Basic for Applications/2. Understanding Objects-en_US.srt 3KB
  259. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/2. Opening and Closing Workbooks-en_US.srt 3KB
  260. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/9. Rows and Columns-en_US.srt 3KB
  261. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/3. If...Then...Else-en_US.srt 3KB
  262. ~Get Your Files Here !/5. Getting Started with Programming VBA/3. Resetting Your VBA Code Upon Errors-en_US.srt 3KB
  263. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/5. Other Windows the Immediate Window, the Locals Window, and the Watch Window-en_US.srt 3KB
  264. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/6. The Cells Object-en_US.srt 3KB
  265. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/2. The Project Explorer-en_US.srt 3KB
  266. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/3. Worksheets vs. Sheets-en_US.srt 3KB
  267. ~Get Your Files Here !/12. Creating User Forms with VBA/8. Test Your Skills-en_US.srt 3KB
  268. ~Get Your Files Here !/10. Looping Your VBA Code/8. Exiting a For Loop-en_US.srt 3KB
  269. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/3. Data Types-en_US.srt 3KB
  270. ~Get Your Files Here !/10. Looping Your VBA Code/4. Stepping-en_US.srt 3KB
  271. ~Get Your Files Here !/10. Looping Your VBA Code/13. Exiting a Do Loop-en_US.srt 3KB
  272. ~Get Your Files Here !/2. Introduction to Visual Basic for Applications/1. Writing Code vs. Recording Macros-en_US.srt 3KB
  273. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/12. The CurrentRegion Property-en_US.srt 3KB
  274. ~Get Your Files Here !/12. Creating User Forms with VBA/6. Validating Form Data-en_US.srt 3KB
  275. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/6. Adding and Removing Modules-en_US.srt 3KB
  276. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/Section Summary.html 3KB
  277. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/Section Summary.html 2KB
  278. ~Get Your Files Here !/1. Welcome to Excel VBA/1. Introduction-en_US.srt 2KB
  279. ~Get Your Files Here !/3. Understanding, Recording , and Modifying Macros/3. Absolute vs. Relative Mode-en_US.srt 2KB
  280. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/3. The Properties Window-en_US.srt 2KB
  281. ~Get Your Files Here !/5. Getting Started with Programming VBA/4. Structure of Sub Procedures-en_US.srt 2KB
  282. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/11. Referring to Named Ranges-en_US.srt 2KB
  283. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/7. Naming Modules-en_US.srt 2KB
  284. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/7. Exercise Using Operators and the Cells Object-en_US.srt 2KB
  285. ~Get Your Files Here !/10. Looping Your VBA Code/5. For Each-en_US.srt 2KB
  286. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/8. Error Handling The On Error Resume Next Statement-en_US.srt 2KB
  287. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/5. Carriage Return Line Feed-en_US.srt 2KB
  288. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/18. Exercise Using Name, and Value-en_US.srt 2KB
  289. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/Section Summary.html 2KB
  290. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/Section Summary.html 2KB
  291. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/The PrintOut Method.html 2KB
  292. ~Get Your Files Here !/10. Looping Your VBA Code/9. Do Until Loop-en_US.srt 2KB
  293. ~Get Your Files Here !/2. Introduction to Visual Basic for Applications/Section Summary.html 2KB
  294. ~Get Your Files Here !/5. Getting Started with Programming VBA/Section Summary.html 2KB
  295. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Section Summary.html 2KB
  296. ~Get Your Files Here !/10. Looping Your VBA Code/Section Summary.html 1KB
  297. ~Get Your Files Here !/10. Looping Your VBA Code/11. Do While Loop-en_US.srt 1KB
  298. ~Get Your Files Here !/12. Creating User Forms with VBA/7. Exercise Dependent Combo Boxes-en_US.srt 1KB
  299. ~Get Your Files Here !/12. Creating User Forms with VBA/1. Introduction to User Forms-en_US.srt 1KB
  300. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/10. The Range Object-en_US.srt 1KB
  301. ~Get Your Files Here !/14. More VBA/5. The Array Function-en_US.srt 1KB
  302. ~Get Your Files Here !/2. Introduction to Visual Basic for Applications/4. How VBA Refers to Objects-en_US.srt 1KB
  303. ~Get Your Files Here !/5. Getting Started with Programming VBA/7. Calling a Function-en_US.srt 1KB
  304. ~Get Your Files Here !/4. Getting to Know the Visual Basic Editor/8. Customizing the Visual Basic Environment-en_US.srt 1KB
  305. ~Get Your Files Here !/2. Introduction to Visual Basic for Applications/3. Containers & Collections-en_US.srt 1KB
  306. ~Get Your Files Here !/10. Looping Your VBA Code/1. Introduction to Loops-en_US.srt 1KB
  307. ~Get Your Files Here !/12. Creating User Forms with VBA/Showing and Hiding a Form Using VBA.html 1KB
  308. ~Get Your Files Here !/16. Thank You!/1. Thank You!-en_US.srt 1KB
  309. ~Get Your Files Here !/12. Creating User Forms with VBA/Section Summary.html 1KB
  310. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/1. Introduction to Decision Structures-en_US.srt 1022B
  311. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/The With Statement.html 1021B
  312. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/AutoFit Columns and Rows.html 996B
  313. ~Get Your Files Here !/9. Using Decision Structures to Branch Your VBA Code/Section Summary.html 972B
  314. ~Get Your Files Here !/12. Creating User Forms with VBA/3. Showing a Form from the VBE-en_US.srt 904B
  315. ~Get Your Files Here !/5. Getting Started with Programming VBA/Calling Procedures with the Same Name.html 888B
  316. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/Syntax Errors.html 875B
  317. ~Get Your Files Here !/14. More VBA/Printing to PDF.html 834B
  318. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/Run-Time Errors.html 773B
  319. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/The Line Continuation Operator.html 752B
  320. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/Declaring Multiple Variables.html 689B
  321. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/The PrintPreview Method.html 633B
  322. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/1. Introduction to Debugging and Error Handling-en_US.srt 612B
  323. ~Get Your Files Here !/12. Creating User Forms with VBA/Tab Order.html 607B
  324. ~Get Your Files Here !/11. Gain User Interactions with Message Boxes & Input Boxes/Section Summary.html 555B
  325. ~Get Your Files Here !/8. Formatting Values with Functions/The FormatPercent Function.html 531B
  326. ~Get Your Files Here !/13. Debugging Your VBA Code & Error Handling/Logical Errors.html 529B
  327. ~Get Your Files Here !/5. Getting Started with Programming VBA/1. Introduction to Writing VBA-en_US.srt 518B
  328. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Inserting Columns and Rows.html 458B
  329. ~Get Your Files Here !/8. Formatting Values with Functions/The FormatNumber Function.html 451B
  330. ~Get Your Files Here !/12. Creating User Forms with VBA/Control Availability.html 435B
  331. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/The Value Property.html 427B
  332. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Deleting Worksheets.html 408B
  333. ~Get Your Files Here !/10. Looping Your VBA Code/Quick Questions For Next Loops.html 407B
  334. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/The Select Method.html 382B
  335. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/ActiveSheet.html 380B
  336. ~Get Your Files Here !/12. Creating User Forms with VBA/Setting the Focus of a Control.html 371B
  337. ~Get Your Files Here !/Bonus Resources.txt 357B
  338. ~Get Your Files Here !/10. Looping Your VBA Code/Quick Answer For Next Loops.html 323B
  339. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/Moving Worksheets.html 313B
  340. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/The Colon Operator.html 298B
  341. ~Get Your Files Here !/6. Getting to Know Variables, Data Types, and Operators/String Concatenation.html 247B
  342. ~Get Your Files Here !/7. Workbooks, Cells, and Ranges/The Name Property.html 203B
  343. Get Bonus Downloads Here.url 183B
  344. ~Get Your Files Here !/12. Creating User Forms with VBA/Closing a Form.html 154B