种子简介

种子名称： Visual Basic for Excel - Microsoft VBA Excel Tutorial
文件类型： 视频
文件数目： 89个文件
文件大小： 336.03 MB
收录时间： 2020-6-7 09:16
已经下载： 3次
资源热度： 190
最近下载： 2024-6-14 23:14

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:3baf2e973dc37f388cd1875e640e61e5d13d6eca&dn=Visual Basic for Excel - Microsoft VBA Excel Tutorial 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Visual Basic for Excel - Microsoft VBA Excel Tutorial.torrent

9. Debugging And Error Handling/8. Speeding Up The VBA Tips.mp49.74MB

1. Getting Started/2. What Will I Get Out Of This Course.mp42.14MB

1. Getting Started/3. The Excel Working Files Explained.mp42.1MB

1. Getting Started/4. What Is VBA For Excel.mp42.56MB

1. Getting Started/5. Excel 2010 Security Settings And Macro Files.mp42.87MB

1. Getting Started/6. The Developer Ribbon.mp41.68MB

2. Macros/1. Recording And Running A Simple Macro.mp42.84MB

2. Macros/2. Editing An Existing Macro In The Visual Basic Editor.mp43.07MB

2. Macros/3. The New Macro Enabled File Type.mp41.9MB

2. Macros/4. Quick Tour Of The Excel Visual Basic Editor.mp43.85MB

2. Macros/5. Watch A Macro Write Your VBA.mp42.56MB

3. Procedures And Functions/1. What Is A Module.mp42.15MB

3. Procedures And Functions/2. Creating A Sub Procedure Manually.mp41.99MB

3. Procedures And Functions/3. How To Call A Sub Procedure.mp42.05MB

3. Procedures And Functions/4. Creating A Function Procedure.mp41.7MB

3. Procedures And Functions/5. How To Call A Function.mp42.22MB

4. Getting Started With VBA Programming/1. Using Comments Within Your VBA Code.mp42.37MB

4. Getting Started With VBA Programming/2. Declaring Variables And Data Types.mp43.84MB

4. Getting Started With VBA Programming/3. The Scope Of A Variable.mp43.08MB

4. Getting Started With VBA Programming/4. The Static Declaration And Variable Expiry.mp43.27MB

4. Getting Started With VBA Programming/5. Constants Instead Of Variables.mp42.15MB

4. Getting Started With VBA Programming/6. An Intrinsic Constant.mp42.11MB

4. Getting Started With VBA Programming/7. String And Date Types Expanded.mp43.63MB

4. Getting Started With VBA Programming/8. Excel VBA Operators.mp45.27MB

4. Getting Started With VBA Programming/9. Arrays.mp42.95MB

4. Getting Started With VBA Programming/10. Multi-Dimensional Arrays.mp41.96MB

4. Getting Started With VBA Programming/11. Dynamic Arrays.mp41.91MB

5. Manipulating Excel Objects/1. Referencing Cells Using The Range Object.mp43.03MB

5. Manipulating Excel Objects/2. The CELLS Property.mp41.76MB

5. Manipulating Excel Objects/3. The OFFSET Property.mp41.52MB

5. Manipulating Excel Objects/4. The VALUE Of Ranges.mp44.89MB

5. Manipulating Excel Objects/5. The TEXT Object Of The RANGE.mp41.93MB

5. Manipulating Excel Objects/6. A Number Of Read Only RANGE Properties.mp45.49MB

5. Manipulating Excel Objects/7. The FONT Property And Colors.mp45.19MB

5. Manipulating Excel Objects/8. Formatting Numeric Values.mp42.36MB

5. Manipulating Excel Objects/9. Add Formulas To Cells Through VBA Code.mp44.12MB

5. Manipulating Excel Objects/10. Common METHODS Of The RANGE Object.mp47.74MB

6. Working With Excel VBA Functions/1. What Is A Function.mp41.06MB

6. Working With Excel VBA Functions/2. Built In VBA Date Functions.mp41.6MB

6. Working With Excel VBA Functions/3. Text Manipulation With VBA Functions.mp42.64MB

6. Working With Excel VBA Functions/4. Determining File Sizes Using FILELEN.mp41.72MB

6. Working With Excel VBA Functions/5. Using Worksheet Excel Functions In VBA Code.mp45.42MB

6. Working With Excel VBA Functions/6. User Defined Functions In Excel.mp42.95MB

7. Controlling Program Flow And Execution/1. Using GOTO And Labels.mp42.58MB

7. Controlling Program Flow And Execution/2. Controlling The Program Flow With IF THEN ELSE.mp42.5MB

7. Controlling Program Flow And Execution/3. Multiple Criteria Plus Nested IFs.mp43.55MB

7. Controlling Program Flow And Execution/4. Adding ELSEIF To Speed Up Execution.mp42.58MB

7. Controlling Program Flow And Execution/5. SELECT CASE As An Alternative To IF.mp42.87MB

7. Controlling Program Flow And Execution/6. The FOR NEXT Loop.mp45.73MB

7. Controlling Program Flow And Execution/7. FOR NEXT With A VBA Collection.mp44.24MB

7. Controlling Program Flow And Execution/8. DO WHILE Loop.mp44.18MB

8. Events/1. How To Create An Event.mp44.52MB

8. Events/2. WorkBook Events - Open.mp46.27MB

8. Events/3. Workbook Events - Closing And Saving.mp45.56MB

8. Events/4. Workbook Triggers - Activate And Deactivate.mp43.76MB

8. Events/5. Worksheet Triggers - Activate And Deactivate.mp42.81MB

8. Events/6. Other Useful Worksheet Triggers.mp46.52MB

8. Events/7. Using Application Events.mp49.02MB

9. Debugging And Error Handling/1. Error Trapping the Easy Way.mp45.22MB

9. Debugging And Error Handling/2. Make The VBA Ignore Errors.mp42.99MB

9. Debugging And Error Handling/3. Interact With The User When An Error Occurs.mp43.28MB

9. Debugging And Error Handling/4. Making Use Of The ERR Object.mp43MB

9. Debugging And Error Handling/5. Debugging Techniques.mp43.99MB

9. Debugging And Error Handling/6. Using Breakpoints To Help Debug.mp44.01MB

9. Debugging And Error Handling/7. Setup And Use A Watch.mp43.56MB

10. Interacting With Users Through Forms/1. Using MSGBOX To Interact With Users.mp46.12MB

10. Interacting With Users Through Forms/2. Use INPUTBOX For Accepting Values From Users.mp44.71MB

10. Interacting With Users Through Forms/3. Selecting A Range With The INPUT Box.mp42.41MB

10. Interacting With Users Through Forms/4. An Introduction To UserForms.mp43.04MB

10. Interacting With Users Through Forms/5. Creating A UserForm.mp43.44MB

10. Interacting With Users Through Forms/6. Using Command Buttons In Excel.mp43.83MB

10. Interacting With Users Through Forms/7. Adding Option Buttons In A Frame.mp44.04MB

10. Interacting With Users Through Forms/8. Adding The Code That Makes The Form Work.mp45.3MB

10. Interacting With Users Through Forms/9. Calling Your UserForm And Validating Content.mp46.1MB

10. Interacting With Users Through Forms/10. UserForm Controls - The CheckBox.mp46.21MB

10. Interacting With Users Through Forms/11. UserForm Controls - ListBox AndOr Combo Box.mp47.99MB

10. Interacting With Users Through Forms/12. Images On UserForms.mp44.4MB

10. Interacting With Users Through Forms/13. Labels And Text Boxes.mp44.11MB

10. Interacting With Users Through Forms/14. Multiple Tabs On A UserForm.mp46.4MB

10. Interacting With Users Through Forms/15. Allowing The User To Highlight A Range.mp43.2MB

10. Interacting With Users Through Forms/16. Scrollbar And Spin Controls.mp46.04MB

10. Interacting With Users Through Forms/17. Controlling Tab Order And Aligning Controls.mp48.16MB

11. Running And Storing VBA Code/1. Trigger A Procedure From The Quick Access Toolbar.mp44.06MB

11. Running And Storing VBA Code/2. Customizing The Ribbons.mp44.64MB

11. Running And Storing VBA Code/3. Adding Buttons To Sheets.mp42.91MB

11. Running And Storing VBA Code/4. Adding A Keyboard Shortcut Trigger.mp42.03MB

11. Running And Storing VBA Code/5. Where To Store Your VBA Code.mp45.53MB

11. Running And Storing VBA Code/6. Adding Code To The PERSONAL File.mp45.96MB

12. Summary/1. So What's Next.mp41.27MB