hello friends, see you again on my channel, in the tik tutorial in this video, I will give a tutorial on how to make an application using vba macro Excel, see the tutorial . Okay, first step is to open Microsoft Excel . is because here we will create an application using vba macro Here I will add the sheet by default Excel opens three sheets here yes sheet1 sheet2 sheet3 I will add another semheet which is sheet 4 I will later make this as the main menu I made on A1 like this is the main menu OK, then I will block up to g1 and i will merge and center then i will make it center and i will enlarge this letter like this then i will give it a bold effect now i will make this the main menu set to 4 now Here I will create three menu buttons by inserting and selecting save here I use just a rectangular one, friends, friends like this Okay, the next step is I will make three copies like this, okay, as if to make it like this, then this again, in the making of this menu button, it is adjusted to the needs of friends, it all depends on the What application do we want to make here? I'm just giving an example, typical friends. I'm just giving the method and the number of these menu buttons depending on the needs of your friends or depending on what application you are making. Now here are three menus. 3 The menu button will open the three sets below, for example, this button I wrote one by Right Clicking on save and selecting edit text for one OK Now then this one button if pressed will open sheet1 then here I make 2C give the names of the buttons OK now on these buttons if pressed will open sheet2 Okay then on button three I will name it three Now and this three button if pressed will open sheet3 OK, so the next step is to make a vba macro formula on these three buttons so that if you click or press it, it will automatically open the set below. OK, let's open it or we code it first on the first button. ASEAN macro here, we choose new, now I will give a script or code because this was for because this was the unite button, friends or menu1 to open sheet 1, so here I write set Hi Active point, great script like this, OK, already a friend -friends Now, after we create this script, we return to the Excel worksheet. Now, let's create a script like this. Thank you, this button is working, my friends, for example, if I press it, Z1 will automatically open. This set will automatically open, we will return to the local area or main menu, then we will create a formula in the menu button, the two methods are the same as assign ma cro then select new and we make soup 2 like this and the active point is like this Ok ok hi then we create again on menu button 3 this is the same way as assign macro and we select new and then we make set 3 Now that's kefir after like this we back again to the Excel worksheet Now after we make the formula or the vba macro code then these three buttons are working, er friends, we press it then it will access sheet1 now then we press menu2 it will open Z2 then if we press button 3 it will open sheet3 then here there is one button that we need to add to each of these sets, namely the button back to the main menu or back to four Now why was the back button made because of this but this later when the application is finished we will hide it friends so that we can control the application, namely The menu button is okay, then we go back to we press the first button then it will open something now on this sheet1 we make the button again li or home button Now, here we insert and select save, still I choose this rectangular one or we can also choose save with arrows like this, now may I give an example, then I will make this arrow name the main menu like Hey friends, after this I will copy into sheet2, then I will copy it to a set of 3 Spikes like this Now after I make a copy like this I will give a macro formula like this Right click on save then assign macro Well, before that, I will explain because this main menu button, we return it to this set of 4, if we press this main menu button, this arrow will open Z4 or return to the main menu okay , let's start making the code. Right click on save then assign the macro we create the code is set14 Hi because it will open set 4 then active like this yeah it's done then we go back to the Excel worksheet we test whether it works or not now it's working a with a friend Then on sheet2 we make the formula sin the same way Right click then assign a macro then new then we make step 4 now then we select the active OK then we return to the Excel worksheet and we select the arrow in set 3 the method is the same as ASEAN macro, then new, then we make a search script, then we select active-active paint, ok, it's over, friends, let's go back again, now I'm just giving a tutorial on the button, friends, later friends, you can fill in any data which is in each set, for example, if we press this button the number one button will open Z1 then if we want to return to the main menu we press here it will return to the main menu and so on if we press on menu two then it will access sheet2 and if we accessing this again, it will return to the main menu as well as on the third button, the method is the same as all buttons work, friends, then. I don't want to make a name for this application. Hi friends, how do we make it here, we edit the text, for example, here I change the other number to eh? Hi student data , for example, the next gang is soldered. school committee data committee, for example school committee data Okay, after we make it like this, for example, if we press the student data button, it will open sheet1. Now on sheet1 we create a table, that is, we create a student data table, for example number 6 a, then gender, then Aa , we make like this date of birth TTL only Then religion Hi, then the name of the parents, okay, here's an example, friends. Now, let's make data like this for each menu. Now, we can make it like this, friends, so to clarify, friends, now this has become data. Then we tidy up the students, friends can also tidy up so that it can be better here I'm just giving an example Okay then If we want to return to the main menu, just press this arrow, it will access the teacher data. So, we create a teacher data table here. Then we want to return to the main menu, press this arrow and so on, we create committee data here and return to the main menu, hi okay after arriving here then we will remove this topset Eh so that the application that we make we really control using the button that we have made we can't move it again from this set the way we select the file menu here and then we select the option now on the menu In this Excel option, we select Advance or Advan, then in this Advan, we scroll down like this and then we look for a way . Hey, we are looking for the topset. Well, here it is, show the set-up. This is unchecked and then we click ok, but below it's gone. To access the set that we made earlier, we only need to use the button that we have created, then to return to the main menu, we just press the like button. This means yes, so we can't move it from below again because the topset is gone. So, how do you beautify the application that you have made, it depends on each other's tastes. Here I am only giving a tutorial on how to make the menu button from make this application then If we want to make it look even better from Hi here onwards we press control and cefla you press the arrow to the right then we Right Click and menstruate Well then it will disappear on this side as well as at the bottom If we want delete, press shift and control, then press the arrow downwards, then we eliminate menstruation. Now, that's all that appears, then. If you want to give a color effect, friends, so that it looks more attractive, you just choose here, you choose which color suits you. for the menu or display of the application that you made, here it depends on the creativity of my friends In managing the application, it's like this, okay, friends, that's the tutorial that I can share this time with all of my friends, if this video is useful for friends, don't forget to like the channel on this video and don't forget to subscribe to the channel me and see you again in my next video which is