From the course: Excel: Macros and VBA for Beginners (2021)
Join today to access over 24,200 courses taught by industry experts.
The VBA environment - Microsoft Excel Tutorial
From the course: Excel: Macros and VBA for Beginners (2021)
The VBA environment
- Let's have a look at key features, in the VBA editor. There isn't a workbook that goes along with this video, but if you want to follow along, I have this workbook that has two sheets, one's called details the others called summaries. I'm going to record a basic macro, so that we have some stuff to look at when we get into the editor. Here we go, I'm already in the developer tab, record macro, I want to name it classes, and then hit "Okay". In cell C one, I want to put number of students, (clicking sound) instructor, days, room, then highlight, home, I want an 18 point font. Change it to Arial Nova, Underline it, make it dark blue and then highlight the columns. Double click to auto widen them, select there and then we can end the recording. I'm going to go down here, select this little white box, stop the recording. Now I'm going to boost this up so we can see better. But see what because I'm about…
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.