From the course: Excel: Macros and VBA for Beginners

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Warnings about VBA and macros: Recorded macros are literal

Warnings about VBA and macros: Recorded macros are literal - Microsoft Excel Tutorial

From the course: Excel: Macros and VBA for Beginners

Start my 1-month free trial

Warnings about VBA and macros: Recorded macros are literal

“

- One big deal about recording macros. The VBA is literal. Let me show you what I mean. One thing you got to know about recorded macros is they will record everything you do. Once you press record, Everything you do is going to be coded until you end the recording. Now I'm going to give you a very simple example just to drive this point home. You may never need a macro like this ever in life but it's about the point of it, okay? I'm in the developer tab. I'm going to record this macro. I'm going to name this macro "Tilt." You can use whatever shortcut command you would like. I'm going to go with Control + Shift + K. Okay. Now up top, we can see "Stop recording," that red square. That's where we'll hit when we're done or we can go down to the bottom. Notice the white square. We can stop the recording at that point. Here is the spectacular macro. Insert, Illustrations, Shapes. I'm going to grab this…

Contents