Join Dennis Taylor for an in-depth discussion in this video Introducing the VBA environment, part of Excel 2010: Macros in Depth.
- View Offline
- Exercise Files
Every time you record a macro, you create a small program using VBA, Visual Basic…for Applications, the programming language of macros.…And the big question in many of your minds would be, what is VBA,…and what do you really need to know about this programming language?…In this particular workbook called Code--notice it's file extension, xlsm--…there are macros here. On the View tab in the Ribbon, rightmost button, Macros >…View Macros, there are a few macros in this workbook.…
We might want to see what the macro code is about.…I recommend that anytime you record a macro that you quickly look at the code.…It's not that you need to know a whole lot about this environment, but you'll…learn more and more about macros as you view the VBA code.…And certainly one method is to select a macro in question--like this particular…one here, Highlight_Value_Cells--and in this dialog box, click Edit. There we are.…This is a macro created in a prior movie that highlights just the value cells…within a given worksheet.…
- 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.