Join Dennis Taylor for an in-depth discussion in this video Reviewing macro examples, part of Excel 2010: Macros in Depth.
- View Offline
- Exercise Files
Before actually creating some macros, it's worthwhile to see some more examples…to deepen the rationale as to why we want to use this great feature.…In this particular worksheet, you see these numbers in millions--nothing…wrong with this at all.…Many people who deal with large numbers, however, might want to use a different format.…I'm just going to highlight these cells here For example, in cell E5 here,…how about that being display as 415.1?…That sounds like something easy to do.…
I'm going to do it manually here by simply right-clicking, going to Format…Cells. And the solution is not one of the built-in number formats, but you need…to go to Custom--and actually you can start with almost any one of these--and…alter it to include a .0 and, believe it or not, comma, comma.…And that will display these values in millions with a single decimal place,…and you could easily imagine someone wanting to have that at his or her figure tips.…And we'll be showing you how you can have macros be executable, or you can…
- Understanding what a macro does
- Recording and adding functionality to a macro
- Running macros
- Creating non-recordable VBA code
- Testing a macro in Step mode
- Joining two macros
- Using loop structures
- Streamlining macros
- Creating a Personal Macro Workbook
Skill Level Intermediate
1. Getting Started
2. Running a Macro (Execute, Play Back, Etc.)
3. Using Visual Basic for Applications (VBA)
Viewing the VBA components6m 50s
4. Recording a Macro in Stages
Recording a simple macro5m 52s
5. Creating Non-Recordable VBA Code
6. Macro Project: Converting a Mailing List into a Database List
7. The Personal Macro Workbook
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.