From the course: Excel: Macros and VBA for Beginners (2021)
Join today to access over 24,200 courses taught by industry experts.
Stepping through the code - Microsoft Excel Tutorial
From the course: Excel: Macros and VBA for Beginners (2021)
Stepping through the code
- Let's say we've recorded a macro. That code is somewhere. Let's look at the code in this video step through it from a very general sense. We're not going to go in to learning code, but it's important to know where it is and just get introduced to it. All right, let's have a look at it. Now we're going to step through some code and we're going to open the StepThrough.xlsm file. And remember, XLSM means that that's an Excel workbook with a macro in it. Double click. Sometimes you'll get a yellow bar across the top of the worksheet saying that macros have been disabled. You can press the button to enable but only if you trust that macro, is a safety feature so if case you've opened the workbook and it has that yellow bar, is okay. Now, stepping through the code is a really cool thing so that you can watch how your code is working. It can help with troubleshooting, it can help If you want to make modifications and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.