Chapter1
Chapter2
VBA Lesson2a https://youtu.be/XAuWIk-x3FU
VBA Lesson2b https://youtu.be/cSL7RYF7O9E
Chapter3
Lesson https://www.youtube.com/watch?v=DC3AYRHexYM&feature=youtu.be
For Next If End If Else
Lesson3a https://youtu.be/WiGGWZv5Qqw
Else if Do Select case Loop inside Loop Reconcile
ExcelVBAStringsLess3
https://youtu.be/whLci0rI9uk
Strings, basics and finding extensions.
VBAStringLess2 https://youtu.be/f8R_JlEs1Uw
Examples. Ed Robinson Fish ABCD..Z
Chapter4
Lesson 6a https://youtu.be/Fv9t7FACkqg
Count -> ColorIndex
YouTube VBA Lesson 6b https://youtu.be/73D7NJ-u-fE
Object-> looping down
YouTube: ExcelVBAAddColours https://youtu.be/jHRhjCT1o3A
Sum color
Chapter5
VBALesson7a https://youtu.be/1qPF1aBpuYY
VBALesson7b https://youtu.be/hKPDs7AQhKo
Chapter6
Properties Methods
VBACh6a: https://youtu.be/-ftf-DczLvY
->.Count
Events:
VBACh6b: https://youtu.be/h59ACWGy4wQ
selectionchange change beforedoubleclick beforerightclick
calculate crossfire-caldwell codename protect
Chapter7
ExcelVBACh7a: https://youtu.be/rDyOBtMVJ5E
->iterate thru w/books
VBACh7b: https://youtu.be/NslzhwzAqic
Count, index, SheetSelectionChange, SheetDeactivate, BeforePrint,
Open, BeforeClose. Join text from 2 w/books.
Chapter8
VBACh8a.avi https://youtu.be/827654wUBJU
columns rows with max greater than iterate value copy
current region ->page 115
VBACh8b.avi https://www.youtube.com/watch?v=_qI8_MA5Wls&feature=youtu.be
see page 115
used range offset lookup udf! Intersect union selection_change-intersect
VBACh8No3.avi https://youtu.be/CCkloh3c0dY
resize dynamic selection areas Intersect done twice areas
allocate for mmerge for cw
Chapter9
VBACh9a https://youtu.be/impiMRnCmV4
command button text box spin buttons option groupname
VBACh9b https://youtu.be/OpdZWtQbUiE
combo box import sheet
Chapter10
VBACh10a.avi https://youtu.be/0I4Llsu0X3s
(bit obscure) email code use fish instead sub/function
pythag exercise byref byval swap byref
VBACh10b.avi https://youtu.be/BAbOV5H-vjs
scope lifetime msgbox udf
Chapter11
VBACh11a https://youtu.be/dDmF4Os3kjE -> Variant Arrays
VBACh11b https://youtu.be/EVjNXrQRjGQ ReDim
u/form list box
VBACh11c.avi: https://youtu.be/SGB4GEGstkQ errors
Chapter12
VBACh12a.avi https://youtu.be/0gJJ7if5dk0 Now()
VBACh12b.avi https://youtu.be/5ukjo8LhTYc DateValue/Part/Serial/Diff
VBACh12c.avi https://youtu.be/UadqvMrVJmo Weekdays BDay How Old Day of birth Mod Leap Year
Chapter13
VBACh13a.avi https://youtu.be/3bC3b7LyfEA
Chapter14
Automation VBACh14a.avi: https://youtu.be/ZTJ8WdpdgII
Windows APIs (Included above)
File Handling VBAFilehandling.avi https://youtu.be/CHOfELInQ78
AddIns CH14AddIns.avi: https://youtu.be/9O1VY7IiEEg