Excel VBA | Macros for beginners| Learn to Write an Excel Macro from scratch! | Abdelrahman Abdou | Skillshare

Excel VBA | Macros for beginners| Learn to Write an Excel Macro from scratch!

Abdelrahman Abdou, Data Analyst & Excel Lover!

Excel VBA | Macros for beginners| Learn to Write an Excel Macro from scratch!

Abdelrahman Abdou, Data Analyst & Excel Lover!

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
120 Lessons (8h 60m)
    • 1. Course Introduction

      2:07
    • 2. Please Follow me

      0:17
    • 3. Recording Macros vs Writing VBA Code

      3:49
    • 4. Understanding Objects in ExcelVBA

      7:18
    • 5. Understanding the VBA Syntax and Parts of Speech

      9:48
    • 6. Activating the Developer Tab

      0:25
    • 7. Recording a basic Macro

      5:04
    • 8. Absolute vs Relative mode in Recording

      3:56
    • 9. Introduction to the Visual Basic Environment

      2:09
    • 10. The Project Explorer

      2:05
    • 11. The Properties Window

      2:17
    • 12. The Code Window

      4:18
    • 13. Immediate, Locals and Watch Windows

      2:31
    • 14. Dealing with Modules

      3:08
    • 15. Writing Comments in Excel VBA

      0:59
    • 16. Introduction and Changing Cell Values

      10:27
    • 17. Adding a text to a cell

      1:27
    • 18. Dealing with Named Ranges

      3:15
    • 19. Value vs Text Property

      3:37
    • 20. Row and Column properties

      2:02
    • 21. The Select Method

      2:12
    • 22. The Count Property

      3:37
    • 23. The Address Property

      9:23
    • 24. The Formula Property

      3:27
    • 25. The Number Format Property

      6:34
    • 26. The Font Property

      8:14
    • 27. Introducing the Cells object!

      5:55
    • 28. Using the Cells collection to affect cells positionally within a range

      5:08
    • 29. Affecting all cells within a sheet

      2:20
    • 30. Combining Range and cells objects

      2:33
    • 31. Selecting Sheets

      5:48
    • 32. Adding Sheets

      11:07
    • 33. Sheets vs Worksheets

      3:54
    • 34. Copying Sheets

      5:15
    • 35. Moving Sheets

      1:16
    • 36. Deleting Sheets

      3:32
    • 37. Introduction to Variables

      6:22
    • 38. Variable Data Types

      9:27
    • 39. Declaring Variables

      14:06
    • 40. Forcing Variable declaration

      4:56
    • 41. Object Variables

      8:28
    • 42. Calling a procedure from another and variable scope

      3:15
    • 43. Public and Private variables

      7:14
    • 44. Declaring Constants

      4:03
    • 45. Referring to Workbooks-Different ways

      3:45
    • 46. Closing Workbooks

      3:17
    • 47. Adding and Saving Workbooks Part 1 - Save method

      4:03
    • 48. Adding and Saving Workbooks Part 2 - Save as method

      10:26
    • 49. Opening Workbooks

      6:18
    • 50. Finding the last row

      8:58
    • 51. Finding the Last Column

      3:39
    • 52. Finding the Next Row

      4:24
    • 53. The With Statement

      3:52
    • 54. Comparison Operators in Excel VBA

      0:59
    • 55. IF Statements- Simple IF Statements

      6:43
    • 56. IF THEN ELSE Structure

      3:21
    • 57. IF THEN ELSEIF Structure

      6:42
    • 58. Nested IFs

      4:21
    • 59. OR /AND logical operators

      7:08
    • 60. NOT Logical Operator

      2:49
    • 61. CASE Statements Part 1 - Single Case Statements

      8:49
    • 62. CASE Statements Part 2 - Nested Case Statements

      6:22
    • 63. GOTO and Labels

      2:44
    • 64. Loops Introduction

      1:26
    • 65. For Next loop

      10:55
    • 66. Exit for Statement

      8:36
    • 67. FOR EACH Loop - Intro

      6:42
    • 68. FOR EACH Loops - More examples

      4:48
    • 69. Do Loop Introduction

      3:49
    • 70. Do Loop Simple Example

      1:27
    • 71. Do until

      1:50
    • 72. Do While

      1:44
    • 73. Do while vs Do until - Movies Example

      3:47
    • 74. Exit Do Statement

      4:57
    • 75. Do Loop Exercise

      0:46
    • 76. The Message Box - Introduction

      3:14
    • 77. Message Box - Inputs

      7:22
    • 78. The Message Box - Capturing the User's Input

      4:30
    • 79. Adding a new line

      2:00
    • 80. Messagebox Exercise

      2:10
    • 81. The Inputbox - introduction

      3:38
    • 82. Inputbox - Example1 - Capturing a user's name

      5:18
    • 83. Inputbox -Employee Database Example Part 1

      5:19
    • 84. Inputbox -Employee Database Example Part 2

      3:59
    • 85. Inputbox Exercise

      1:44
    • 86. Introduction to Error Handling

      9:04
    • 87. Different error types in action

      3:48
    • 88. On Error Statement Resume Next

      2:26
    • 89. On Error GoTo Statement

      4:25
    • 90. Resetting the error handling Status with On Error Goto 0

      4:38
    • 91. The Err Object

      7:18
    • 92. Setting a Breakpoint

      1:57
    • 93. Worksheet Events - Worksheet Selection Change

      8:01
    • 94. Worksheet Events - Worksheet Activate event

      3:16
    • 95. Worksheet Events - Worksheet Deactivate event

      2:11
    • 96. Worksheet events - Worksheet Before delete event

      1:31
    • 97. Worksheet Events - Worksheet Before Double Click Event

      7:55
    • 98. Worksheet events - Worksheet Before Right Click

      2:54
    • 99. Worksheet Events - Calculate Event

      3:03
    • 100. Worksheet Events- Enabling and Disabling events

      2:50
    • 101. Worksheet Events - Worksheet Change event

      11:04
    • 102. Worksheet Events - Follow Hyperlink Event

      2:41
    • 103. Worksheet events Exercise

      1:01
    • 104. Workbook Events - Workbook Open Event

      4:46
    • 105. Workbook Events - Workbook Activate event

      2:06
    • 106. Workbook Events - Workbook BeforeSave event

      6:09
    • 107. Workbook Events - Workbook AfterSave event

      3:49
    • 108. Workbook Events - Workbook Before Close event

      8:50
    • 109. Workbook Events - Workbook Before print event

      2:37
    • 110. Workbook Events - Workbook De-activate event

      1:59
    • 111. Workbook Events - Workbook New Chart event

      7:47
    • 112. Workbook Events - Workbook New sheet event

      2:33
    • 113. Workbook Events - Workbook sheet calculate event

      3:24
    • 114. Workbook Events - Sheet Deactivate Event

      5:38
    • 115. Workbook Events - Workbook Follow Hyperlink Event

      2:02
    • 116. Workbook Events - Workbook Window Activate event

      5:37
    • 117. Workbook Events - Workbook Window De-activate Event

      1:35
    • 118. Workbook Events - Workbook Window Resize Event

      1:29
    • 119. Workbook Events Exercise

      1:09
    • 120. Thanks for Watching

      0:18
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

766

Students

--

Project

About This Class

Description

Learn step by step how to automate your spreadsheets using the power of programming in Excel! 

This course is designed to teach beginners who have no background in programming how to program in Excel VBA!

What you need before taking this course

  • The will to learn!
  • You need to be at least an intermediate user of Excel, know how to write formulas, draw charts and use pivot tables.

A Powerful Skill at Your Fingertips

Learning how to program in Excel will increase your market value and allow you to save time on your spreadsheets.

It will also be a great way to tap into the world of programming, and will help lay the foundation in case you need to learn any other programming language!

Who is the target audience?

  • Someone who wants to learn how to program/write code in Excel using the Visual Basic for Applications (VBA) language.
  • Needs to know how to write formulas, use pivot tables and draw charts in Excel.

Meet Your Teacher

Teacher Profile Image

Abdelrahman Abdou

Data Analyst & Excel Lover!

Teacher

Hi, I'm Abdelrahman and I'm and Excel Lover :)

I'm also the founder of ExcelBonanza.com, a website dedicated to making you better at Microsoft Excel!

I'm a Certified Microsoft Excel Expert with 10 years of experience in Excel.

I strive to make my courses engaging and informative to help you get better at Excel!

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Your creative journey starts here.

  • Unlimited access to every class
  • Supportive online creative community
  • Learn offline with Skillshare’s app

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

phone

Transcripts

1. Course Introduction: Hello and welcome to this XlV B A for beginners Course. My name is Abderahmane Abou and I will be your instructor on this course. So a little bit about myself. I have a degree in chemical engineering. I have five years of experience is a data analyst and eight years overall experience in Excel on. And I have been an online instructor since 2015 and I'm a certified Microsoft Excel expert . So first of all, who should take the scores? So this course is geared towards beginners who want to learn xlv a So if you only know how to record Macron's But you don't know how to write VB a code than this course is for you. If you are aware the experienced with writing VB a code than this course is not for you. Okay, so let's discuss the course contents. So first of all, we're gonna have an introduction section where we're going to understand what the objects in excel VB are and what are the methods and properties. And we're going to understand the V b a syntax amongst other topics. And we're also going to be introduced to the visual basic environment we're going to learn about the range object, the cells collection, object, and we're gonna learn about dealing with worksheets in xlv a on. Then we're gonna go into variables and then we're going to learn about dealing with workbooks and xlv b a and then we're gonna go through XlV be a logic such as finding the last row if statements, case statements and also some other topics. We're also going to discuss loops on this course and then loops help you repeat some pieces of code over and over again until a certain condition is satisfied. And that's when you need to break out of the loop on. Then we're also going to learn how to interact with users using message boxes and import boxes, and we're gonna learn how to do air handling on. Then we're gonna learn about events in Excel vv eight. Okay, so I'm still excited to start that course with you and without further ado, let's get started 2. Please Follow me: thank you for enrolling into this class before we start the class. Please make sure to follow me on skill share by clicking on the follow button at the top of the screen or on the bottom right hand corner of the screen, so that you'd be able to receive updates about new classes that I release or any changes to existing classes. 3. Recording Macros vs Writing VBA Code: Hey, guys, welcome back. So in this video, we're going to speak about the difference between recording macros and writing VB a coat. So when you run a recorded macro Excel just repeats the steps you recorded exactly as you've recorded them. So you record some steps and excel will just repeat them exactly as they have been recorded . However, when you write VB a code, you get much more power and it enables more functionality on your code so you can make decisions and repeat actions and much more So recording macros has limited functionality and writing code opens a world of possibilities. And this is what we're gonna learn on this course. We're gonna learn mainly how to write vb a coat. So let's have an example here. Let's say we have this stable here, having some sales persons and their commissions so you can see here We've got some sales persons and the commission of each sales person, so I could record a macro too bold the names of the sales persons. Okay, So as you can see air, I could record a macro to just build the names of all sales persons, and you can see her. The names have been bold ID, however, in order to have a macro bold the name of a sales person on Lee. If their commission is greater than $10,000 this cannot be done by recording. So is absolutely impossible to record a macro that can make a decision to bulled the name based on the commission. If it's more than $10,000 However, this can be easily achieved when I write VB a code or when I write my Mac Rose. So this very simple case can show you that writing VB a code is much more powerful than recording macros. So someone could ask, Why would we have the option than to record Micro's? So why did Microsoft include the option? If it's just better to write VB a code? Well, there are a couple of reasons for that. The 1st 1 is that someone might not be able to write VB a code. He didn't have the skill to do so, and he might be wanting to do a task that is fairly simple, so he can just record that macro and just play whenever he wants to achieve that task. And the second thing is that sometimes you may want to write a macro to do something. However, you do not know the method or property for that thing that you want to do. So you don't know the property to change or the method that would enable you to do that. And we will speak about methods and properties later on in the course. But you basically don't know what co two, right. So you could record the action in order to know what piece of code to write and then take it from there and start writing your macro. And this is a very common way to learn about something that you do not know how to do in Excel v b A. So you just record it. No, the method or property that you need to use and just take it from there. Start writing your coat. OK, so this was a quick overview about the difference between recording macros and writing VB a code. Thank you very much, guys watching this video and I'll see you on the next one 4. Understanding Objects in ExcelVBA: Hey, guys, welcome back. So in this video, we're going to speak about objects in Excel V B A. So vb A or the visual basic. For applications, language is an object oriented language, so V B A is full of objects. It revolves around objects, actually, and all these objects have properties and properties are like characteristics and methods which are like behaviors or actions or verbs that the object conduce. So, for example, when you describe someone as being told, okay, someone's heights is a property. If you think about that person as an object, then his height is a property. And also when you say that someone is walking or someone is running, running or walking is a method. If you think about someone as an object, then walking or running is a method. And if you think about stuff around us as objects, so, for example, a car is an object, and it has some properties and methods, so part of the properties of the car is its color. So color is a property because it's something that you can describe. The car with the cars type, for example, is well, is it in SUVs that event, the car's brand. So is the more CDs to BMW Toyota. All these are properties, and the car has some methods as well. So moving when the car moves from one place to another, that is a method. So any object, if you think about it, has properties and methods. And this is how XlV be a works. If you think about your mobile phone as well. Your mobile phone has some properties such as its color, such as its screen size and its brand as well is in an iPhone. Is is Samson. All these are properties for the mobile phone, and it has some methods as well. Part of the methods are the actions that the mobile phone can do. It can call. It, can text. It can access the Internet. All these are methods. If you think about yourself as well as an object, you have some properties and methods. So part of the properties are your heights, your eye color, your skin color. All these are properties. Some of the methods that you can do you can eat. You can sleep, you can walk, he can run. All these are methods. If you think about yourself as an object. Now V. B. A has a lot of objects, and as an example of the objects that you will encounter in XlV B A. There is the range object, so the range object is basically the cells. In an Excel spreadsheet. A range object can be a single cell or multiple cells, so the range object has some properties, like the value of the cell. For example, the value is a property, and it has some methods, such as the select method, which is the method that used to select the cell. Okay, this is a method. This is an action that you're going to do to the cell. So this is why it's a method. There's also the worksheet object. The worksheet is an object, so it has some properties, such as its name. So the name is a property, the name of the worksheet. And there are also methods like the select method to select the worksheet. This is an action that you're going to do, so this is a method. There's also the copy method work she dot copy method for copying the worksheet. The worksheet dot move as well. The method for moving a worksheet as well. This is a method or inaction that you're going to do to the worksheet. There's also they sell workbook object so your workbook as well is an object. It has some properties, such as its name as well, and it has some methods, such as opening the workbook, so workbook that open is a method. Closing the workbook dot close is a method as well, and we will learn about that in more detail as we progress through the course. There's also the Excel application object, so the Excel as an application is also an object that has some properties and methods. And also you need to understand that objects can contain other objects and they're called container objects. So, for example, the Excel application object contains the Excel workbook object, right, because the Workbook Excel workbook is part of the Excel application on Also, the Excel worksheet is part of the Excel workbook object as well, because the worksheet is gonna be insight. A workbook and also the range object is contained inside the worksheets object as well. Okay, so you need to understand the idea that objects can contain other objects also objects can be part of a collection. So we've got the idea off collections in xlv being collections are like different families . So we get the work sheets collection, for example. So this is like the worksheets family. Okay, The family of worksheets and all objects that are part of a collection will have the same properties and methods. Okay, so when we say the worksheets collection, that means that every worksheet belongs to this particular collection and that all the work sheets will have the same properties and methods. We've also got the work books collection. So this is another family in XlV be a the workbooks family and the workbooks family contains all the workbooks in XlV B A and all the workbooks. Because they belong to this family that is called the collection have the same properties and methods so or workbooks. And exactly they will have the same properties and methods. There's also this sells collection object so oversells will belong to the cells collection object And why are collections useful in excel? The V A While collections enable you to run code for all objects belonging to the same collection so you can loop through a collection of objects to perform an action toe Every member of the collection and we will learn about loops later on in the course. So basically you can go through each member of a collection and performance action to that . Members weaken, for example, go through each cell in the cells collection and type a certain value to all the cells in the cells collection. For example, perform any other action. Okay, so collections are very useful because the enable us to run code for all objects belonging to the same collection. And we will see that as well as we progress into the course. Okay, guys. So that's it for objects in excel. VB A Thank you very much watching this video and I'll see you on the next one. 5. Understanding the VBA Syntax and Parts of Speech: Hey, guys, welcome back. So in this video, we're going to speak about the V B a speech or the V B A syntax, or how the V b A language is written so v b A is an object oriented language as we've explained before, and that means that objects or announce they come first. So in order to understand the V b a syntax or how the V B A language is written, we're gonna actually compare it to how the English language is written. So in English, you would say, kick the bowl. However, in VB a objects or announce our most important so they come first. So if you want to say kick the bowl using V B A, you would put the noun first. So if you want to write a sentence using Vehbi, eh, you would write the noun first sowed right now ndadd verb or object dot method, and therefore, if you want to say kick the bull using the V B a syntax, you would say bull dot kick. So is it can see here. The noun, which is the bowl, comes before the verb, which is kicked. Two. It's a Boldak cake. If you want to say in VB a Syntex, some other examples as well that you would write using VB. A Syntex is like dinner dot eat or car dot drive. So if you want to open a workbook in V B A, you would say workbook dot open. If you want to activate a worksheet, you would say worksheet dot Activate some examples of objects or announce in Excel Off course, or the cell is an object of workbook. The worksheet a chart as well, is an object, and we've explained that before some examples as well off collection. We've explained collections before in XlV b A. So some examples of collections or they're considered as actually plural noun are the cells collection, which is a plural or it contains cells, and also the Worksheets collection, which contains worksheets and workbooks collection, which contains all workbooks as well. So we're just reiterating the idea of having collections in Excel VV eight. Now we're speaking about collections because we want to speak about how to identify items in a collection. So if you've got a collection of items, how do you identify a certain item in a collection to make sure that you use the right item or the item that you intend to use. So, for example, if you've got three bowls here, we've got a soccer or a football bowl and we've got a bowling bull and we've got a basketball. So how do make sure that we kick the right bull, which is, if we're gonna kick a bull? It should be the soccer bowl, right? We don't want to kick the bowling bowl, and we don't want to kick the basketball. So there are actually two ways of identifying an item in a collection. There is a less used way in a less recommended way, which is using the index number, and although it's a less used way, you will use it sometimes. But you're not going to use a lot as the other way, and the other way is using the name. But let's speak about using the index number first. So if you wanna use the index number and you want to kick the first bowl in this collection and the first is basically counting from left to right, then you would right. Bulls won dot kick, so if you right bulls won dot kick. This way you will be able to kick the soccer bowl. However, what happens if these Bulls got reordered? And that means what happens if one of your friends puts the bowling bowl to be the first bowl from the left hand side and you right? Bulls won dot kick and you kick the bowling bull. Ouch. That's gonna be a painful experience, right? It's gonna be very painful to kick a bowling ball. So this is why it is not recommended to use the index number to identify an item in a collection. So the better way is to actually use the name of the object. So it's better to write roles. Soccer dot So if you do that, you will make sure to kick the correct bull, which is the soccer Bowl, regardless of its position in this collection. So if the soccer bowl is the first or the second or the third, you're going to make sure that the soccer bowl is the bull you kick. Okay, so it's better to use the name of the item rather than its position. Now let's speak about methods or verbs, so methods in XlV be a or verbs have actually parameters and parameters act like adverbs in the English language. So if you say Bulls soccer dot kick and then you would right direction, Colin equals right force Colin equals hard. The direction and the force are considered parameters or adverbs in XlV v A, and they describe how the verb or the method which is kick is done. So here were saying that we want to kick the bull to the right and with the hard force. So if you see a call in equals operator, this indicates that you've got an adverb or a parameter, and parameters are. Adverbs can sometimes be confusing because if you know the default order off the adverbs, you can leave off the name. So if you know that the default order for the direction and the force are that the direction comes first and then the force parameter the nuclear I, instead of writing bulls sucker don't kick direction called equals right force calling equals hard. You could write bulls soccer dot kick right comma hard. Of course, we do not have a kick method in XlV B A, and we do not have a direction and a force parameters, but you get the idea. So in V B A, you could write shapes that at shape. So we're using the ad shape method on the shapes collection object in order to add a new shape, and then you would right left call unequal stand top Colin equals 20 with Colin equals 30. Height colony equals 15 and these parameters are adverbs identified. The position off the shape when it is inserted so you can actually write shape. Start at shape 10 comma 20 comma, 100 comma 15 without explicitly writing the parameters and it will still work. Okay, the code will work absolutely fine. However, if you do that, if you write the code without explicitly writing the parameters, the code will be confusing, right? If someone else reads your code and you write shapes that at shape 10 common 20 comma 100 common 15. If somebody reads your code this way, they will be confused. They will not understand what you mean because not everyone remembers the positions off the parameters or the order of the parameters. Right. So writing the values of the parameters without specifying the actual parameters is a bad programming practice So even though your code is still gonna work, it is actually a about programming practice. And it is better to explicitly right your parameters or adverbs. Okay, so we've spoken about parameters. Now let's speak about properties or adjectives. So properties, what they do is that they describe an object. So, for example, when you're I active, she dot name equals my sheet. The property name here gets the value off my sheet, and that means that the name of the active sheet is gonna be my sheet. And also, properties do not use the colony equals construct. Okay, so the colony equals is exclusive for parameters. So whenever you see a colony equals, that means you've got a parameter here, and you can set a variable equal to the value of a property. So, for example, you can set variable X to be equal to the name of the active worksheet. By writing X equals active, she dot name, and we will see how to do that in the future, on the course as well. Okay, so let's summarize what we've explained on this video. So a noun in the English language is equivalent to an object in XlV B A and a plural noun is equivalent to a collection and think of different collections as different families. A verb in the English language is equivalent to a method in XlV B A and an adverb is equivalent to a parameter. And also an adjective in the English language is equivalent to a property in XlV v a. Okay, so I hope that was informative for you about understanding the V b A Syntex. Thank you very much, guys, watching this video and I'll see on the next one. 6. Activating the Developer Tab: Okay, So one of the first things that you'd want to do before taking this course is to activate the developer tab on the ribbon. You can activate the developer tab on the ribbon by just right clicking anywhere on the ribbon and then clicking on customize the ribbon on. Then you're going to choose customize ribbon here. And then here you have the developer top here. You can just check the check box here for developer and click. OK, and you will have the developer top activated. 7. Recording a basic Macro: Hey, guys, welcome back. So in this video, we're going to speak about how to record a basic macro. So in order to record a basic Makary need to go to the developer tab on the ribbon and then click on record macro. So this way you're able to record some actions and then play them back whenever you want. So as you can see here, I've got a dollar box that enables me to name the macro so I can name it my micro, for example. And the naming of the macro has some restrictions. So, for example, you cannot put a space on the name of the micro. So if I put a space here and click OK, you're going to get this hour here. The syntax of this name is not correct. So basically, you cannot put a space. You cannot put an exclamation more a dollar sign. So basically, there are some signs here on the keyboard that you cannot use. However, you can actually use an underscore if you want to, so I can emit my macro this way. And here you can assign a short cut key so it can be control and any other key on the keyboard and you can make it control and shifted. And here, for example, also, you have the option to store the macro either in this workbook, which is this work with this currently open here in the school Book one or you can store in a new workbook. So this way, if you click OK in, your book will be open and the MCA will be stored in that workbook. Or if you choose to store in the personal macro workbook this way it will be starting in a workbook called the Personal Macro workbook. And this enables you to have the macro available in each and every workbook that you open in excel. From now on, I'm just gonna choose to start in this workbook and I'm gonna click. OK, so this way I've started recording the macro What I'm going to do. I'm going to select cell a one and type my name and then press enter and then I'm going to stop recording. So now I've recorded a macro and only does is that it puts my name in cell a one. Now to examine that macro, you can go under the developer top here, you can go to my crows and here on my macro, you conclude con ed it and then you can have a look at the code of the recorded macro. You can also click on old and F 11 on your keyboard. And here on module one year you will find the macro. And a module is basically a container for your Marko's. Think about it this way. We'll speak about it as well later on in the course. Okay, so we've recorded a macro and xlv B A has just recorded our actions and transformed them into some code. So now I can actually delete here the contents of cell a one. And if I just go to Macron's again and here on my macro, I click on Run the macro is going to run and is gonna put my name in cell a one. So as you can see, Your Excel just repeated our actions again. And our actions here are to be secure so that sell anyone put my name in the cell and then because when you press enter, you go to the cell just below it. So here we've gone to sell a to sell it to has been selected. And if you do not understand what this code does, do not worry. By the end of the course, or even by the middle of the course, you be able to understand it perfectly fine. So don't worry about the code at the moment, OK, one more thing I want to tell you as well is that if you need to save a workbook that contains a micro's, if I press controlling as to save my workbook here and here on save eyes, if I click on browse, you can see her. I have the chance to save the workbook. You need to make sure to save it as an excel macro enabled workbook. You cannot save it as an Excel workbook because it normal Excel workbook will not save a macro. One more thing I want to show you as well is how you can assign a macro to a button or a shape so you can insert a simple button here by going to the insert button here under the developer tab and clicking on button. And here you have a button, and then if you click OK, the button will be inserted. So in order to assign the macro to that bun, you can right click on the button itself and click on a sign macro, and then assign your macro here that you recorded called my macro, for example, and then click. OK, And then whenever you press that, bend them back, crow is going to run. You can also do it with the shape so it can insert any shape here, insert a shape and then right click on it a sign, macro and a sign the macro as well. And this works with any form control here under the developer tab on the insert button here so you can insert any active extra form control and then assigned the macro to that control using the same way. And if you need to edit the text inside so you can right click here, click on edit text and you can at it the text as well. Okay, so that's it, guys, for recording a basic macro. Thank you very much watching this video and I'll see you on the next one 8. Absolute vs Relative mode in Recording: Hey, guys, welcome back. So in this video, we're going to discuss the difference between recording macros in absolute mode and recording them in relative mode. So the best way to illustrate the differences to illustrate it with an example. So, basically, air, I'm gonna start recording a new micro, so I'm gonna go to the developer top here, Click on record, Macro. And the first backer is gonna be an absolute mode. So I'm just going to write its name. It's gonna be absolute macro, and then I'm going to click. OK, so now I'm going to select cell a one and put a one in it and then put two and sell a two and then three in cell a three and then I'