Highline Excel 2016 Class 26: Macro Recorder Basics & Copying VBA Code From Internet

Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htm
In this video use Macro Recorder to record six Macros:
1. (00:12) Basics for Recorded Macros (VBA)
2. (05:55) Absolute Reference Macro: Format report that always has the same number of columns and rows. This Macro is stored in Personal Workbook.
3. (18:32) Absolute & Relative Reference Macro: Format report that that has an unknown number of rows
4. (26:38) Relative Reference Macro to convert vertical records into a proper data set with horizontal records
5. (31:09) Search for VBA Code online: Function to spell out numbers as words
6. (33:04) Search for VBA Code online: Add or count cells with red fill
7. (35:52) Form Control Button to Add Record to Existing Proper Data Set on different sheet.
8. (39:37) Summary

YouTube Channels to learn VBA:
ExcelVbaIsFun: https://www.youtube.com/channel/UC9OIUFZfYqELCFwWxT7OpKQ
Dinesh Kumar Takyar: https://www.youtube.com/channel/UC-vzNYU9x8IYPk_r89mGvXA
Book by Bill “Mr Excel” Jelen: Excel 2016 VBA and Macros:
https://www.amazon.com/Macros-Content-Program-MrExcel-Library/dp/0789755858/ref=sr_1_2?ie=UTF8&qid=1467918868&sr=8-2&keywords=excel+2016+vba

Видео Highline Excel 2016 Class 26: Macro Recorder Basics & Copying VBA Code From Internet канала ExcelIsFun