We want to expand this idea that as we work with macros and go into VBA, back and forth into the world of VBA and back into Excel, we want to become familiar with the techniques for why we want to alter a macro and then how we do that.
(2:09) – Looking at Visual Basic code with Alt + F11
And let’s look at the code. I always recommend looking at the code every time you record a macro, even if you’re not going to make changes. It’s good to start getting familiar with more visual basic. Alt + F11 opens the visual basic editor to create or edit macros.
Why should I learn VBA (Visual Basic for Applications)?
Excel Macros are written in the VBA programming language
You can make changes to your recorded macros if you know VBA
You can reuse bits of one macro in another macro
Watch out for my next e-mail on Excel 2010 Macros – coming soon!