Loading...

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

35,248 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jul 18, 2016

Download Files: https://people.highline.edu/mgirvin/A...
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/UC9OI...
Dinesh Kumar Takyar: https://www.youtube.com/channel/UC-vz...
Book by Bill “Mr Excel” Jelen: Excel 2016 VBA and Macros:
https://www.amazon.com/Macros-Content...

Loading...

Advertisement

to add this to Watch Later

Add to

Loading playlists...