Join Dennis Taylor for an in-depth discussion in this video Running macros from the Quick Access toolbar button, part of Excel 2010: Macros in Depth.
- View Offline
- Exercise Files
For macros that you run frequently, you might want to decide to have a new…button in the Quick Access Toolbar at the top of your screen…in addition to a keystroke shortcut, or instead of a keystroke shortcut. We also…want to introduce the idea that if you plan to use a macro in many different…workbooks, we store the macro in a different location.…This not a course in using functions, but if we look in column B here, …something interesting is going on.…The code in column B uses the column A data, and it gets rid of this unnecessary…spaces like we see in row 7 here, for example, and here, too.…
It also uses proper case to clean up the data.…But when you work with formulas that clean up data--typically in an extra column…like this--eventually what you want to do is to turn these into the pure values,…in other words, the results.…We would like to have this cell, the first one, simply consist of Baxter, Donna.…No formulas, throw all that away. Keep the results.…And many of you know how to do this multi-step process.…
- 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.