Join Dennis Taylor for an in-depth discussion in this video Viewing and modifying VBA code, part of Excel for Mac 2016: Macros.
- [Instructor] We're looking at the workbook…called Introduction-after recording,…and it's the reflection of what happened…in the previous movie, where we actually recorded a macro.…At different times when recording a macro…you might want to look at the actual…Visual Basic for Application code that was created.…Every time you record a macro,…you have created a small program,…in that language which we call VBA.…So, in this workbook, because we know xlsm…means there are macros here, we can get to the macro code…by going to the Developer tab in the ribbon,…and the far left button says Visual Basic Code,…click this button.…
And suddenly we see a different window,…now you might want to maximize it or might not,…I suggest not, but, what we will see is,…first of all down the left-hand side,…a name for each open file,…in this case there's only one file, and we see the phrase…VBAProject followed by the name of the file,…might not be seeing it all, as in this case,…and there will be times where this could be narrower,…so you might want to make it wider.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with existing macros
- Creating macros with the recording process
- Viewing and modifying VBA code
- Running a macro from the Developer or View tabs
- Running a macro from a keystroke shortcut
- Running a macro from an object or picture
- Creating and updating the Personal macro workbook
- Recording a formatting macro
- Expanding a macro with an IF statement
- Creating interactive macros
- Stepping through macros