Excel Video 410 gives you a behind the scenes look at what the Macro Recorder is doing in Visual Basic for Applications when it records a macro. Watch how I use Alt+F11 to open the Visual Basic Editor and follow along as I record a macro in Excel. If you want to learn how to write code in VBA, this is a great way to do it. You can always look up how to write specific code and it may help to read the help file to understand specific options for an Excel feature, but watching the Macro Recorder work can point you in the right direction quickly when you’re learning new code in VBA.
VBA includes some powerful debugging tools to help you understand what the VBA code is doing. We’ll start with some of those tools in the next Excel Video. Thanks for watching.
