Join Dennis Taylor for an in-depth discussion in this video Viewing the VBA components, part of Excel 2010: Macros in Depth.
- View Offline
- Exercise Files
There are additional aspects of the VBA environment that you should…become familiar with.…Once again, a reminder: the quick way to enter the Visual Basic window is to…press Alt+F11, and this is also the keystroke shortcut for returning from…Visual Basic, Alt+F11.…When you come into the world of Visual Basic here, the screen isn't always…looking the way you want it to. And things can go wrong here and there; it can…be a little confusing.…I'm not suggesting that the screen as we see it now is the way it will…always appear to you.…
But many, many times--and you'll see this depicted in books on macros as well--…what you're likely to see on the left side of the screen--and that portion can…be made wider or narrower,…there's no strong reason for doing this right now--…but the upper-left corner typically is occupied by a section where you'll see the word "Project."…I'm going to purposely get rid of this because there will be times when you…jump into this environment, particularly if it's the first time you're using…
- 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.