From the course: Excel: Macros in Depth (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
The VBA window and VBA components
From the course: Excel: Macros in Depth (Microsoft 365)
The VBA window and VBA components
- [Instructor] The more you work with macros in Excel the more important it is to understand some of the elements of the programming language behind the scenes. VBA, visual basic for applications. In this workbook, it's called workbook with macros, we expect to find some macros. We can go to the view tab, choose macros, we see some macros listed. Be sensitive to the idea that sometimes the setting down below here might say all open workbooks. And if you have other open workbooks open, it's not obvious at first which macro is where. In this case, this is the only workbook I have open, but from time to time you will want to click this workbook. So if we want to see the code behind one of these macros, we can either click the macro and choose edit or we can jump into the visual basic window much faster simply by not having come here and press alt F11, the keystroke combination. You'll be using that a lot as you work with macros.…
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.