VBA for Daily Fantasy
-
Intro & File downloads (4:05)
-
1: How to Start with VBA code (2:26)
-
2: Using Macro Building to Write VBA Code (1:06)
-
3: How to Edit & Run a Macro (3:54)
-
4: Declaring Variables (3:39)
-
5: Cell Reference (4:33)
-
6: IF Statements (4:20)
-
7: For Loops (4:46)
-
8: Insert Comments into your Code (2:49)
-
9: Code to Stop Screen Updating (2:12)
-
10: How to Create a pop up Message Box (1:29)
-
11: Call Another Macro in your code (3:15)
-
12: Password Protect VBA Code (1:49)
-
13: Shortcut keys and Buttons to trigger macros (2:17)
-
14: Debugging Errors (2:39)
-
15: Find Correct Code with Macro Builder (2:53)
-
16: Example - Run Certain Code based on Value of Cell (5:20)
-
17: Using Input Box to Get Data from User (3:33)
-
18: Example - Refresh Web Data (4:19)
-
19: Run Macro upon Opening Workbook (2:55)
-
20 - Example - Copy Daily Game stats to Complete Game Log List (9:48)
-
21 : Example - Save sheet as csv file (3:24)
-
22: Example - Email a worksheet (4:08)
-
23: Create User Defined Functions (13:33)
