1
00:00:00,440 --> 00:00:07,520
Hello and welcome back to another class of our course about the complete introduction to VBA with Microsoft

2
00:00:07,520 --> 00:00:08,250
Excel.

3
00:00:09,200 --> 00:00:14,540
So in this class, what I want to do is basically practicing everything that we just saw and really

4
00:00:14,540 --> 00:00:16,340
creating a formula.

5
00:00:16,340 --> 00:00:22,130
Well, not a formula, but really creating a macro from scratch with all the knowledge that we just

6
00:00:22,130 --> 00:00:22,490
have.

7
00:00:23,270 --> 00:00:25,430
So what I want to do today is pretty simple.

8
00:00:25,430 --> 00:00:30,440
I want to practice a little bit more what we have, what we have learned in the past few classes.

9
00:00:31,460 --> 00:00:33,410
This is exactly what we are going to do.

10
00:00:33,920 --> 00:00:36,470
So what I want to create is really a simple macro.

11
00:00:36,490 --> 00:00:39,260
So let me just show you what I was thinking about.

12
00:00:39,680 --> 00:00:45,110
So my goal here is not to make something complicated, but really a basic macro that we will that we

13
00:00:45,110 --> 00:00:45,620
can use.

14
00:00:46,190 --> 00:00:51,740
So we are going to generate eight mahu in which we are going to have a random function like we always

15
00:00:51,740 --> 00:00:51,890
do.

16
00:00:52,850 --> 00:00:56,150
So basically, step one, what I want to have is a name.

17
00:00:57,950 --> 00:01:03,850
Then I want to have an age, then I want to have a number.

18
00:01:04,190 --> 00:01:11,360
And basically this number will be somewhere between one and let's say 30 or I'll decide between which

19
00:01:11,360 --> 00:01:12,260
number and which number.

20
00:01:13,280 --> 00:01:16,940
Then for the name I want to write down eight or any other name.

21
00:01:16,970 --> 00:01:19,610
I can decide it for the age.

22
00:01:19,610 --> 00:01:21,410
I want to have a random number.

23
00:01:21,440 --> 00:01:28,310
So we are going to use this formula, which would be around between, as we always do, let's say in

24
00:01:28,310 --> 00:01:31,040
this case is going to be between 20 and 30.

25
00:01:32,420 --> 00:01:38,510
And finally, for the number, I want to have pretty much the same thing, but instead having a number

26
00:01:38,510 --> 00:01:41,630
that will be generated between zero and 30.

27
00:01:42,800 --> 00:01:44,450
So she will at the end.

28
00:01:44,450 --> 00:01:47,000
What I want to have is just something like this.

29
00:01:47,270 --> 00:01:52,460
But if I want to if I want to put all this inside of a Marquel, it's possible I can put it inside of

30
00:01:52,460 --> 00:01:52,960
a macro.

31
00:01:53,270 --> 00:01:55,160
But let's say I want to write it by myself.

32
00:01:55,190 --> 00:01:59,240
So in this case, I'm writing all this by myself from scratch.

33
00:01:59,630 --> 00:02:00,470
Is it possible?

34
00:02:01,250 --> 00:02:02,690
Well, the answer is yes.

35
00:02:02,700 --> 00:02:06,860
And my goal today is really to practice writing all this.

36
00:02:06,860 --> 00:02:08,000
And this is exactly what will do.

37
00:02:08,450 --> 00:02:10,310
So what I'll ask you guys to do is pretty simple.

38
00:02:10,310 --> 00:02:16,160
Just go in your developer type right there and you can click on your visual basic element right there.

39
00:02:16,490 --> 00:02:20,000
And you will be redirected to this page right here.

40
00:02:21,930 --> 00:02:28,080
So, as always, what we are going to do, we are going to create another module we have here Module

41
00:02:28,080 --> 00:02:31,830
one, and what we are going to do, we are simply going to create another module.

42
00:02:31,840 --> 00:02:37,050
So we are going to go into insur and we are going to insert another module.

43
00:02:37,230 --> 00:02:39,380
So just to be sure, we're in module two.

44
00:02:40,050 --> 00:02:40,390
All right.

45
00:02:40,410 --> 00:02:41,840
So what's going to happen right now?

46
00:02:41,850 --> 00:02:46,620
We have our module and we are able to create whatever we want inside of this module.

47
00:02:46,630 --> 00:02:49,050
So basically we can create our macro.

48
00:02:49,230 --> 00:02:49,830
Pretty simple.

49
00:02:50,700 --> 00:02:57,460
So just start by deleting all this and I'll start I'll start writing down my macro.

50
00:02:57,480 --> 00:02:58,290
So sure is.

51
00:02:59,640 --> 00:03:03,140
So pretty simple, how exactly do we start our Michael?

52
00:03:03,170 --> 00:03:10,290
So, as I explained, we need to start our macro with the sub procedure and how exactly we can start

53
00:03:10,290 --> 00:03:10,800
with this.

54
00:03:10,830 --> 00:03:11,660
Well, it's pretty simple.

55
00:03:11,670 --> 00:03:14,660
We are going to insert once again a procedure right there.

56
00:03:15,150 --> 00:03:17,910
So here you guys can select the type of procedure you want.

57
00:03:18,090 --> 00:03:22,030
If you want to create your own function, you will select function for properly.

58
00:03:22,040 --> 00:03:27,860
It's pretty much the same thing when I do want to create a macro that will use this procedure.

59
00:03:28,830 --> 00:03:33,490
And in this in this case, we are going to give a name to our micro.

60
00:03:33,510 --> 00:03:39,470
So let's call it I don't know how we can call it Final Micro.

61
00:03:41,430 --> 00:03:42,180
So here we go.

62
00:03:42,180 --> 00:03:43,620
And we just click on.

63
00:03:43,620 --> 00:03:44,070
Okay.

64
00:03:44,940 --> 00:03:49,920
So as you can see, as we have our public sub and sub, so basically we have our sub procedures that

65
00:03:49,920 --> 00:03:50,790
have been treated.

66
00:03:51,150 --> 00:03:52,800
So our micro have been created.

67
00:03:52,800 --> 00:03:56,820
And from here, what we can do, we can start writing down our code.

68
00:03:58,020 --> 00:03:58,370
All right.

69
00:03:58,680 --> 00:04:04,590
So as I explained, basically the first step of what exactly we want to do is pretty simple.

70
00:04:04,860 --> 00:04:07,370
We want to write down a name.

71
00:04:07,650 --> 00:04:10,710
So what exactly we are going to use for this?

72
00:04:11,490 --> 00:04:12,280
It's pretty simple.

73
00:04:13,260 --> 00:04:17,310
Well, we are going to use some elements and I'm going to describe them step by step.

74
00:04:17,340 --> 00:04:18,630
So first of all, what to do?

75
00:04:18,930 --> 00:04:22,330
We want to select the active cell that we are working on.

76
00:04:22,350 --> 00:04:27,570
So basically this cell right there and how exactly we are going to do this.

77
00:04:28,020 --> 00:04:28,910
So it's pretty simple.

78
00:04:28,920 --> 00:04:30,480
We are going to write it down.

79
00:04:30,490 --> 00:04:33,030
So we are going to start writing down active.

80
00:04:33,480 --> 00:04:38,410
So we'll just give a few pointers and we'll write it down right there.

81
00:04:38,430 --> 00:04:39,540
So it's going to be active.

82
00:04:40,430 --> 00:04:48,200
So and then what exactly we are going to use as a comment, what to do in this active cell, we want

83
00:04:48,200 --> 00:04:50,500
to write down a name.

84
00:04:50,510 --> 00:04:52,910
So in this case, how exactly will write down your name?

85
00:04:54,080 --> 00:04:56,600
So we are going to use another element.

86
00:04:56,610 --> 00:04:58,630
So in this case is going to be formula.

87
00:05:00,590 --> 00:05:01,090
Here we go.

88
00:05:01,310 --> 00:05:02,680
So we have it right there.

89
00:05:05,770 --> 00:05:14,590
Ah, one, you want to go, we have it right here and the final step is what exactly we want to write

90
00:05:14,590 --> 00:05:17,770
down so you can decide whatever we want to write down.

91
00:05:17,800 --> 00:05:21,030
So if I want to write down a name, I can write the name.

92
00:05:21,040 --> 00:05:22,540
I want to write down anything else.

93
00:05:22,720 --> 00:05:26,910
Well, I can do it so I can decide whatever I want to write down.

94
00:05:28,270 --> 00:05:30,890
Just change the language of my keyboard.

95
00:05:32,140 --> 00:05:33,920
All right, so here's what I want to write down.

96
00:05:33,940 --> 00:05:38,020
I want to write down a name so we want to have a name for our person.

97
00:05:39,790 --> 00:05:40,230
All right.

98
00:05:40,750 --> 00:05:44,530
So now that we have a name, next step, what exactly we want to do.

99
00:05:45,100 --> 00:05:47,970
So we want to move to another cell.

100
00:05:47,980 --> 00:05:51,310
So basically, we want to move from this cell to this cell right there.

101
00:05:51,340 --> 00:05:52,540
So how exactly we will move.

102
00:05:53,020 --> 00:05:57,530
So there is another way that we are going, what we are going to use active cells once again.

103
00:05:58,450 --> 00:06:03,880
And in this case, we want to so basically to be able to we're going to use the offset function.

104
00:06:04,300 --> 00:06:06,650
So pretty simple how exactly we write this down.

105
00:06:07,060 --> 00:06:13,180
So we are going to copy the active cell that we have right here and what exactly we want to we want

106
00:06:13,180 --> 00:06:13,770
to do right now.

107
00:06:14,080 --> 00:06:22,240
We want to move from this cell to this cell right there in the range eight one, which is in all this

108
00:06:22,420 --> 00:06:22,770
range.

109
00:06:24,070 --> 00:06:25,970
And this is the same set.

110
00:06:25,990 --> 00:06:27,380
The second step is really moving.

111
00:06:27,940 --> 00:06:29,370
So we are going to do it right now.

112
00:06:29,380 --> 00:06:31,410
So we are going to use the offset function.

113
00:06:32,530 --> 00:06:33,410
So upset.

114
00:06:34,360 --> 00:06:39,340
And in this case, we are moving from one zero one.

115
00:06:41,130 --> 00:06:48,300
So we're moving from zero and one on the side, then in what range exactly we are going to move, we

116
00:06:48,300 --> 00:06:54,660
are going to move in the range in this case, eight one, which means our table.

117
00:06:54,840 --> 00:06:55,800
So eight one.

118
00:06:58,680 --> 00:07:02,760
Here we go, and we are going to select this subcircuit.

119
00:07:05,230 --> 00:07:09,680
So once we have done this step, what what exactly we want to do?

120
00:07:10,270 --> 00:07:11,200
It's pretty simple.

121
00:07:11,200 --> 00:07:13,610
We want to write down each.

122
00:07:13,750 --> 00:07:19,460
So right now we have our second line of code and now it's time to basically write down the salient element.

123
00:07:19,720 --> 00:07:22,240
So how exactly we are going to write down the second element?

124
00:07:22,270 --> 00:07:22,980
Well, it's pretty simple.

125
00:07:22,990 --> 00:07:26,380
We are going to reuse this formula right here.

126
00:07:27,380 --> 00:07:34,190
Which is active sell formula or one seat one, so we'll just copy everything and we'll pass that right

127
00:07:34,190 --> 00:07:38,570
there so we can run it and write down each right here.

128
00:07:39,200 --> 00:07:40,000
So pretty simple.

129
00:07:40,370 --> 00:07:41,530
Everything works fine.

130
00:07:41,870 --> 00:07:48,110
So if we want to try just this piece of the formula, we can do it.

131
00:07:49,240 --> 00:07:54,040
So we'll have our name and our age, basically, this is exactly what we have wrote down.

132
00:07:57,580 --> 00:07:58,150
So here we go.

133
00:07:58,180 --> 00:07:59,620
We'll come back right there soon.

134
00:07:59,800 --> 00:08:02,230
Until now, we can see that everything works fine.

135
00:08:02,710 --> 00:08:03,030
All right.

136
00:08:03,040 --> 00:08:08,470
So right now that we have our name and are each, the next step will once again be moving another cell.

137
00:08:08,480 --> 00:08:13,970
So we have our name right there are each right there and want to generate a random number right here.

138
00:08:14,290 --> 00:08:16,790
So this is exactly what we are going to do right now.

139
00:08:16,810 --> 00:08:22,110
We are going to generate a random number, but before generating well, before writing the number,

140
00:08:22,120 --> 00:08:24,370
what we need to do is pretty simple.

141
00:08:24,370 --> 00:08:26,560
We need to move up another step.

142
00:08:26,590 --> 00:08:27,880
So basically another cell.

143
00:08:27,880 --> 00:08:28,240
Sorry.

144
00:08:28,260 --> 00:08:33,250
So what we'll do is simply copy this formula right there, because this would be the next step of what

145
00:08:33,250 --> 00:08:34,160
exactly we need to do.

146
00:08:34,990 --> 00:08:40,300
So we'll jump off one step so we can copy this formula because it's pretty much the same thing.

147
00:08:40,300 --> 00:08:47,200
If you want to jump from two cases just right down to if you want to go back to cases, we will write

148
00:08:47,200 --> 00:08:48,100
down minus two.

149
00:08:48,130 --> 00:08:52,240
So in this case, want to jump off just one case, so we'll write down one.

150
00:08:53,870 --> 00:08:54,280
All right.

151
00:08:54,610 --> 00:09:00,390
Next step we want to do want to reuse this formula, but instead of each one to generate will be number.

152
00:09:01,090 --> 00:09:02,320
So we'll do it right there.

153
00:09:03,730 --> 00:09:04,460
So here we go.

154
00:09:04,480 --> 00:09:06,490
So instead of each we want to generate.

155
00:09:06,490 --> 00:09:07,000
No.

156
00:09:09,440 --> 00:09:13,190
All right, so right now that we have all this, what exactly?

157
00:09:14,150 --> 00:09:19,010
So we have down name, we have rolled down each we have Rudan number now.

158
00:09:19,010 --> 00:09:25,090
We want to go back one, two steps and go under one step.

159
00:09:26,210 --> 00:09:29,030
So how exactly we are going to write down this.

160
00:09:29,570 --> 00:09:30,410
So pretty simple.

161
00:09:30,410 --> 00:09:36,170
We are going to reduce the active step right there to move while the active cell, the offset function

162
00:09:36,650 --> 00:09:40,790
to be able to move inside of our well, inside of our micro.

163
00:09:41,240 --> 00:09:44,200
So let me just run the macro and show you what it looks like until now.

164
00:09:45,360 --> 00:09:49,000
So, as I explained, we have created the name, we have created the age, we have created number.

165
00:09:49,440 --> 00:09:50,480
So now it's time to move.

166
00:09:50,490 --> 00:09:54,930
So we're moving from here to there to there and down of one.

167
00:09:55,380 --> 00:09:59,650
So we are going to use this function right there, which is active cell offset zero.

168
00:09:59,970 --> 00:10:01,620
Well, in this case, it's not going to be zero.

169
00:10:01,620 --> 00:10:02,810
One is going to be something else.

170
00:10:03,390 --> 00:10:05,230
So copy and paste that right there.

171
00:10:05,580 --> 00:10:09,840
So, as I said, we need to move back up to cells and down one cell.

172
00:10:09,850 --> 00:10:12,540
So here is to move up or down the front.

173
00:10:12,540 --> 00:10:14,190
To move up is going to be minus.

174
00:10:14,490 --> 00:10:16,530
If one is done down, it's going to be plus.

175
00:10:16,560 --> 00:10:22,010
So in this case, we are moving one down and minus two in the back.

176
00:10:22,020 --> 00:10:28,840
So we're moving minus two to minus one, minus two and down of one to four to go up.

177
00:10:28,890 --> 00:10:30,570
One is going to be minus one instead.

178
00:10:31,890 --> 00:10:32,550
So here we go.

179
00:10:33,090 --> 00:10:34,660
Right now, we have everything that we need.

180
00:10:35,570 --> 00:10:37,260
Next step, what exactly we need to do.

181
00:10:37,290 --> 00:10:39,390
So pretty simple in this cell.

182
00:10:39,390 --> 00:10:42,850
Now that we moved to the cell, we want to write down a.

183
00:10:43,110 --> 00:10:45,340
So in this case, the name will be eight.

184
00:10:45,690 --> 00:10:49,230
So what we'll do just once again, we use this formula right there.

185
00:10:50,490 --> 00:10:53,220
So active cell, the formula or one C1.

186
00:10:53,580 --> 00:10:59,280
And in this case, we can give a name to our person so we can give it any name that we want.

187
00:10:59,730 --> 00:11:02,250
And in this case, let's give it a.

188
00:11:02,270 --> 00:11:07,870
So as I said, it's going to be then the next step is pretty simple.

189
00:11:07,890 --> 00:11:10,380
Once again, we need to move up another cell.

190
00:11:10,770 --> 00:11:12,750
So right now we are right there.

191
00:11:13,020 --> 00:11:15,060
Want to do want to move from here to there.

192
00:11:15,270 --> 00:11:16,510
So how exactly will move?

193
00:11:17,070 --> 00:11:17,880
It's pretty simple.

194
00:11:17,880 --> 00:11:20,460
We are going to reuse another formula.

195
00:11:20,470 --> 00:11:23,070
So basically we're going to use this formula right there.

196
00:11:24,960 --> 00:11:30,990
So since we're moving of just one cell on the right next step, it's going to be writing down another

197
00:11:30,990 --> 00:11:31,450
formula.

198
00:11:31,650 --> 00:11:34,760
So in this case, we want to write down the formula, read between.

199
00:11:35,010 --> 00:11:36,810
So how exactly we write down this formula?

200
00:11:36,840 --> 00:11:37,720
Well, it's pretty simple.

201
00:11:37,980 --> 00:11:44,890
Well, we are going to use the same formula that we use right there, which is Formula or one C1.

202
00:11:44,910 --> 00:11:51,510
So this function right there and instead of writing down something, well, writing down a name or just

203
00:11:51,510 --> 00:11:55,480
a letter or a number, what we're going to write down, we're going to write down or function.

204
00:11:55,510 --> 00:11:57,840
So it's going to be equal to what exactly?

205
00:11:57,960 --> 00:12:00,270
It's going to be equal to round between.

206
00:12:00,270 --> 00:12:08,190
So write it in capital letters just to remember that we're writing down a function right there.

207
00:12:08,580 --> 00:12:12,630
So we're going to generate a random number that will be between.

208
00:12:12,750 --> 00:12:14,540
So just a mistake right there.

209
00:12:19,410 --> 00:12:20,430
So, Rend.

210
00:12:23,890 --> 00:12:24,520
Between.

211
00:12:27,190 --> 00:12:33,820
And in this case, want to generate a random number that will be between 10 and 20, so they said something

212
00:12:33,820 --> 00:12:34,980
that is pretty simple.

213
00:12:37,810 --> 00:12:44,400
And now we have created what we have created until now, so we have created our macro until the age.

214
00:12:44,680 --> 00:12:48,270
So what we can do, we can basically just try it out.

215
00:12:48,460 --> 00:12:53,890
So we'll go right there, will delete everything, and we'll try out our macro to see if until now it

216
00:12:53,890 --> 00:12:59,620
works fine before writing down the last step or if we have a certain problem with our macros, we'll

217
00:12:59,620 --> 00:13:03,550
come back in our visual basic will run pretty much everything.

218
00:13:03,550 --> 00:13:06,250
So we'll come back right there and we'll run everything.

219
00:13:06,610 --> 00:13:08,720
And as we can see, everything works fine.

220
00:13:09,130 --> 00:13:12,970
So finally, the last step is pretty much the same, the same thing as right there.

221
00:13:12,980 --> 00:13:14,860
We're going we're moving of one cell.

222
00:13:15,800 --> 00:13:21,200
And what exactly we're going to do right now, well, it's pretty simple, we're simply going to change

223
00:13:21,320 --> 00:13:26,090
the numbers that are inside the realm between some go right here.

224
00:13:26,310 --> 00:13:29,630
Instead of being between 10 and 20, we are going between.

225
00:13:29,630 --> 00:13:32,730
We're going to be between zero and third.

226
00:13:33,050 --> 00:13:35,720
So right now, we have all our function ready.

227
00:13:35,990 --> 00:13:39,050
Well, our Maku ready so we can run it to see if it works fine.

228
00:13:39,360 --> 00:13:41,370
Those can see everything works fine.

229
00:13:43,490 --> 00:13:46,140
Now, let's say I want to put some of my numbers.

230
00:13:46,140 --> 00:13:52,370
Well, some of my elements in capital letters and other elements are well, not in capital letters but

231
00:13:52,370 --> 00:13:55,320
in bold, for example, or any other things.

232
00:13:55,640 --> 00:13:56,630
Well I can do it.

233
00:13:56,660 --> 00:13:58,850
So let's say, for example, instead of name.

234
00:13:58,850 --> 00:13:59,120
Right.

235
00:13:59,450 --> 00:14:01,450
I want to put my name in bold.

236
00:14:01,610 --> 00:14:03,650
So how exactly out will do it?

237
00:14:03,680 --> 00:14:04,370
So pretty simple.

238
00:14:06,590 --> 00:14:12,270
So first thing that we want to do is simply come back right there and we are going to add another element.

239
00:14:12,590 --> 00:14:15,590
So in this case, we are going to use the fund.

240
00:14:15,610 --> 00:14:22,520
So basically we're going to use the selection function and we're going to use fund and simply use the

241
00:14:22,520 --> 00:14:24,390
board, as we learned in the first class.

242
00:14:24,740 --> 00:14:26,510
So this is exactly what we're going to do.

243
00:14:26,570 --> 00:14:28,130
So we'll just write down the selection.

244
00:14:29,190 --> 00:14:38,060
And in this case, what we want to do is simply using selection that in this case, what exactly we

245
00:14:38,060 --> 00:14:38,650
are going to do.

246
00:14:38,670 --> 00:14:41,680
So we're coming back and we're using that fund.

247
00:14:41,690 --> 00:14:45,090
So we're using fund and what exactly in the fund we want to use.

248
00:14:45,110 --> 00:14:48,700
We want to use Bolt so we don't want to change nothing right there.

249
00:14:49,100 --> 00:14:54,080
We simply want to change board or make making making it into italic, whatever.

250
00:14:54,110 --> 00:14:57,110
So we're going to simply add the bolt board.

251
00:14:57,140 --> 00:14:59,060
I don't want to play too much with the other stuff.

252
00:15:00,950 --> 00:15:01,790
So pretty simple.

253
00:15:01,820 --> 00:15:04,380
We are coming back to our element right there.

254
00:15:04,820 --> 00:15:08,350
So what what exactly what do we want to write right now?

255
00:15:08,360 --> 00:15:13,910
So we have our selection, so we want to select our fund and then inside of our fund what to do.

256
00:15:14,540 --> 00:15:16,460
We want to make my name bold.

257
00:15:17,180 --> 00:15:18,620
In this case, we have arbo.

258
00:15:19,220 --> 00:15:20,330
And do we want it both?

259
00:15:20,600 --> 00:15:21,260
Well, yes.

260
00:15:21,260 --> 00:15:22,550
So we will write down.

261
00:15:22,610 --> 00:15:23,030
True.

262
00:15:24,050 --> 00:15:30,710
And right now, if you run our function, our Microsoft, so you can see the name is both so pretty

263
00:15:30,710 --> 00:15:31,100
simple.

264
00:15:31,430 --> 00:15:33,610
We'll just put it in capital letters at the end.

265
00:15:34,220 --> 00:15:38,380
So if we run everything, you'll see the name is going to be in vaults.

266
00:15:38,400 --> 00:15:39,920
We'll run it next to it.

267
00:15:40,430 --> 00:15:41,030
Pretty simple.

268
00:15:41,030 --> 00:15:44,170
We can run it right now so can see everything works fine.

269
00:15:44,570 --> 00:15:49,370
So if you guys want to add some details that say, for example, you guys want to change this part right

270
00:15:49,370 --> 00:15:52,160
there, the name will basically you can do it there.

271
00:15:52,160 --> 00:15:54,450
I just change it to put it board.

272
00:15:54,450 --> 00:15:59,120
They can, for example, change change it to add the italic parts will make it bold and italic.

273
00:15:59,720 --> 00:16:05,810
If, for example, I want to change this right there and basically add something else to it, I don't

274
00:16:05,810 --> 00:16:09,110
know, add a type of cases.

275
00:16:09,440 --> 00:16:10,550
I'm able to do it.

276
00:16:10,670 --> 00:16:12,950
If I want to change the color, I'm able to do it as well.

277
00:16:13,910 --> 00:16:16,340
So as long as it's under this set.

278
00:16:16,370 --> 00:16:17,540
So basically I'm working on this.

279
00:16:17,550 --> 00:16:21,820
So then here this line of code says that I'm moving of one cell.

280
00:16:22,100 --> 00:16:27,170
So here at the second cell where I'm writing down each and everything that I want to do with each,

281
00:16:27,170 --> 00:16:29,490
I can write it under under this cell.

282
00:16:29,510 --> 00:16:34,600
So basically, all the modifications that I want to do to this cell, I can write them down right there.

283
00:16:34,610 --> 00:16:35,820
Same thing for no.

284
00:16:36,620 --> 00:16:41,930
So after that, I'm moving of well, I'm moving of two cells in the back, so I'm coming back right

285
00:16:41,930 --> 00:16:42,200
there.

286
00:16:42,470 --> 00:16:47,570
Everything that I want to do as a modification right here, I'm going to write it under this function

287
00:16:47,570 --> 00:16:48,060
right there.

288
00:16:48,920 --> 00:16:50,620
Same thing for all the other functions.

289
00:16:50,620 --> 00:16:55,250
So basically, if I want to make make it bold, I can make it bold if I want to make it italic, for

290
00:16:55,250 --> 00:16:55,610
example.

291
00:16:55,610 --> 00:16:56,510
So I'll just write it down.

292
00:16:56,510 --> 00:17:02,350
So selection that I'm working with font and in this case, I want to make it italic.

293
00:17:02,810 --> 00:17:05,270
Well, I'm it's possible to do it.

294
00:17:05,690 --> 00:17:08,030
Just write down the true.

295
00:17:09,930 --> 00:17:14,640
And I can run my microphone, as you can see, it will change so you can see the name has changed to

296
00:17:14,640 --> 00:17:18,840
my macaron right here because I finished my code, I started right there.

297
00:17:18,840 --> 00:17:19,700
So it's pretty simple.

298
00:17:20,130 --> 00:17:28,890
So if I delete everything and I, I come back to my visual, to visual basic studio and I run it, as

299
00:17:28,890 --> 00:17:30,650
you can see, it works pretty fine.

300
00:17:30,660 --> 00:17:34,710
So as I want it to work, so it's once again pretty cool.

301
00:17:35,790 --> 00:17:40,200
So one other problem, as you can see right there, what what happens is that this true?

302
00:17:40,590 --> 00:17:45,740
Well, the true right here have been applied to all of the elements right there.

303
00:17:46,020 --> 00:17:47,400
So what exactly will need you do?

304
00:17:47,400 --> 00:17:52,620
I will need to add, for example, selection from that board pretty much everywhere and write down Truffaut's

305
00:17:52,620 --> 00:17:55,440
once again, this is the way to write down the code.

306
00:17:55,980 --> 00:17:58,050
You can write it down in other ways.

307
00:17:58,620 --> 00:18:02,700
But once again, this is a way that you guys can write down the code and modify everything that you

308
00:18:02,700 --> 00:18:05,280
guys want to modify inside of it.

309
00:18:06,350 --> 00:18:12,530
So I hope you understood how exactly we have ruled our country right now, so you can see it's not that

310
00:18:12,530 --> 00:18:15,710
complicated to write, to write them.

311
00:18:17,150 --> 00:18:18,440
It's just a question of practice.

312
00:18:18,440 --> 00:18:22,550
So basically, if you want to add some more details to this code that we have right there, you can

313
00:18:22,550 --> 00:18:22,810
do it.

314
00:18:22,820 --> 00:18:23,550
It's up to you.

315
00:18:24,380 --> 00:18:27,140
And once again, as you can see, it's not that complicated.

316
00:18:27,530 --> 00:18:30,950
So it's at first class gets into our next class.