1
00:00:00,660 --> 00:00:06,540
And welcome back to another class of our course for the complete introduction to VBA with Microsoft

2
00:00:06,540 --> 00:00:07,060
Excel.

3
00:00:07,680 --> 00:00:11,990
So in this class, we are going to start the practice part.

4
00:00:12,240 --> 00:00:19,830
And basically what we need to do is just set up everything to be able to work the right way with Microsoft

5
00:00:19,830 --> 00:00:20,250
Excel.

6
00:00:21,660 --> 00:00:22,410
So pretty simple.

7
00:00:22,410 --> 00:00:25,620
The first thing that you guys will need is the developer tab.

8
00:00:25,620 --> 00:00:27,540
So I don't know if you guys have it.

9
00:00:28,260 --> 00:00:30,030
It should be somewhere right here.

10
00:00:30,420 --> 00:00:32,340
So what I'm going to teach today is pretty simple.

11
00:00:32,350 --> 00:00:39,100
We are just going to learn how to well, basically how to modify this part right here.

12
00:00:39,420 --> 00:00:45,210
So basically, you able to you will be able to add or delete some parts, for example, right there,

13
00:00:45,210 --> 00:00:46,920
or simply add this sometimes.

14
00:00:47,280 --> 00:00:53,580
So in your case, probably is going to be the developer and even the PowerPoint tab or any other tab

15
00:00:53,580 --> 00:00:54,650
that you guys want to add.

16
00:00:54,960 --> 00:00:59,310
But for the purpose of this course, we are going to require the use of the developer.

17
00:00:59,310 --> 00:01:05,420
And so pretty simple, what to do is simply click on the file button right here.

18
00:01:06,150 --> 00:01:08,350
And when it's all done, you simply go down there.

19
00:01:08,370 --> 00:01:10,350
So we are going to go to options.

20
00:01:11,010 --> 00:01:16,200
Then you should be on a page, looks something like this, and then you will customize your ribbon,

21
00:01:16,890 --> 00:01:17,670
which is pretty simple.

22
00:01:17,670 --> 00:01:19,260
It's going to be right there.

23
00:01:19,590 --> 00:01:23,700
So you can see here you can do whatever you want with your Iribarne.

24
00:01:23,940 --> 00:01:27,030
So basically you have the home, which is the top right there.

25
00:01:27,270 --> 00:01:33,990
You have the insert and the for each of those steps, you can withdraw or add some things so you decide

26
00:01:33,990 --> 00:01:35,700
what you want to withdraw, what you want to add.

27
00:01:36,390 --> 00:01:37,080
So pretty simple.

28
00:01:37,080 --> 00:01:40,000
You can simply check all the tabs that you want to have.

29
00:01:40,020 --> 00:01:43,530
So basically all my tabs are checked, so I have them all the right there.

30
00:01:44,250 --> 00:01:50,220
But normally you guys should not have the developer types asking you to do is simply to check it.

31
00:01:50,370 --> 00:01:54,800
So you can see here you will have a few things code Arin's controls and XML.

32
00:01:55,500 --> 00:02:01,530
So simply check the developer tab and it should appear straight after this.

33
00:02:02,070 --> 00:02:08,220
So you should have your developer tab right here and then you can do whatever you want with this developer

34
00:02:08,220 --> 00:02:12,290
tab and it should work, should work properly.

35
00:02:12,300 --> 00:02:18,520
So this is basically the starting point of where we are going to start to write down or our code.

36
00:02:18,870 --> 00:02:22,440
So that's a first class guys into our next class.