Visual Basic for Applications (VBA) for Analysts
language: EN
WEBVTT
How can I interact with your machine?
Well, okay, you're going to subtract yes,
start now, but yeah,
so you need to use parentheses.
No, no, no, no, no, the column is number five, one, two, three, four,
no, the column is number six, and you need to be two,
so the start now is number five,
so you need to start now with minus one, right?
Yeah, like if the column plus one equals six and I need to get two,
yeah, so it's five, three,
minus one, look this, look this, I'm going to,
we have DIC your machine,
we have five here, five, six,
seven, and in the six,
I have five, six, seven, okay?
Something like that. Okay.
You wrote number five as a start number, right?
We need that this number moves to this column, right?
Yeah.
So we need one, two, three, four.
You have four here, and this four is just the number you wrote, minus one,
so this is what we need,
the number you wrote, minus one.
But instead of minus one,
but there's still the plus one here.
No, the plus one is another thing.
You need, you need, no my code, baby.
No my code.
Yeah, but I just don't know why,
why I need to start with minus one, minus one, all my names.
If you, if we need, if you need,
I'm going to do this, okay?
Do you want, do you want to do this and this?
Remember, remember this is a,
remember this, this is what we have before we use input, okay?
Oh, you have a new folder.
Look, look, look my, look my, my screen, please, look my screen.
Yeah.
This is what we had before we use input box, remember?
Yeah.
This is before, so if we will use,
if we use this without input box, it works, works as, as we want.
But, but when we start using input box,
the start number move the columns.
What numbers of columns move?
Move this.
If I write a number, number five,
moves four columns.
If I write six, it moves five columns and so on, right?
Is it okay or not, or not?
Let me do it again.
Let me do it again.
I'm going to give you all of this.
This is the first example, right?
It's not, they're going to do it again.
This is the first example, okay?
Now, if I write that goes from one to 12,
we use this to start in the second place, okay?
Okay.
Look this, I'm going to change this number one for five, okay?
Number one for five.
Just in the row columns, sorry, in the row here, okay?
Look this, okay?
So, let's go into two cities.
We have one, two, three, four.
How many spaces do we have?
Four, right?
I change it by five and we have four spaces.
I'm going to change it for several.
We have one, two, three, four, five, six.
Okay, so if I change this number, it moves minus one.
If I write ten, the number of spaces is going to be nine.
If I write eleven, the space will be ten.
See it again?
Okay.
So, if I need to these values start here,
I'm going to need to do this.
This number, seven, minus, or less one.
Okay.
I need to subtract this number.
I'm going to do it again.
Okay.
If this is eight, I need to change this for eight.
And now we will start.
Yes, that's what I don't understand.
So, in the formula, zero row plus one, minus eight, minus one.
No.
Look, you're going to see my formula.
You're going to see my formula.
The difference in my formula is that this plus one is here.
It's just a difference.
Look my formula.
I can change it here.
And it's the same.
Yeah.
Minus one, right?
We need to do this.
Okay.
But remember that call goes from here to here.
It's a variable, this one.
It's not a static.
Static is this number.
This is a static.
This is a variable.
It's changed.
Remember we're in a loop.
The first number of call is a star number.
For example, five.
Five.
The next six, seven.
So, it's going to change.
This is not.
This is fixable.
You don't understand, right?
No, no.
You don't understand me very well.
I don't understand very well, but I can't allow you to do things like that.
Okay.
Well, I will think in a better way to explain you.
Not now.
I think for tomorrow, the first time.
That is, well, let me think to explain it in a better way.
Okay.
But now, in this moment, I need to know that you understand how to use loops.
It's the first of all.
Do you know how to use for, how to use do while, how to use do until, right?
Yes, but I think with all of that, I need to practice, right?
Yes, I know.
We're going to practice tomorrow.
We're going to take at least two hours to practice this.
Okay.
To improve our skills.
Okay?
Don't worry.
Yeah.
Don't worry.
I will prepare very similar examples with this.
Right?
So, the other way that I need that you understand is how to use input loops.
And I think you got it, right?
Yeah, that's what I know.
Yeah.
Okay.
So, let's going to make a very simple example.
Okay?
You're going to do this.
I need that you use an input box to answer for the age of a person.
Okay?
And I need you to display a message with the mother age that has 20 more years.
For example, if I write that I have 20 years, it's going to display a message that my
mother has 40 years.
Okay?
Okay.
Okay.
Okay.
Great.
That is great.
Okay.
So, you can use a very well input box and message box and use very well the variables.
That's very, very good.
Okay?
And we have to make now an example.
What about if I wrote my birthday?
Okay.
And I need that display the message with my age.
That's the exercise.
We grow in an input box.
My age.
My birthday.
Okay.
And this place a message with my age.
So, we need to calculate the years between today and my birthday.
You know how to do it or we do it tomorrow that?
Okay.
I'm going to try.
But I can't get it.
Okay.
And it.
Yeah, that's very good.
I think it's integer because it's an H, right?
The answer I think is integer because it's going to be an H.
But won't it have a decimal point to it?
No, because we are going to subtract years and years are integers.
But what is it, 32.5 years?
Oh, come on, let's, let's, let's, let's do it.
Don't worry, it's okay.
We have a function called year that they start the year of our date.
Oh, okay, then can you show me?
Because I didn't know that.
Yeah, just a function.
The main function is year, yes.
Like am I supposed to know that?
I don't know what to do with this now.
No, because now, like in the function, open parentheses and write the date.
Oh, so you're just, you're not writing the full date.
You're just writing the birthday year?
I'm going the other way.
Are you okay?
Are you all right?
Yes.
Okay, I'm going to do it.
I'm going to try to do it.
This is some page from the new year.
And I'm going to use current date.
I'm going to use the age as integer.
Okay.
We're going to use another page since input date.
Okay.
Now, this is input path.
Print date.
We're going to, and this is going to see tomorrow, but I'm going to now just to see it.
We have see date.
See they transform a string to date.
So input date is a string, right?
I wrote in the input box a string looks like a date.
Okay.
But I did that the time is a date.
So I transform this string using this function to a date.
So birthday really is a date.
Do you credit this or not?
I've just never seen that see date before.
I don't know what that is.
I haven't looked it up.
Yeah, okay.
So I think that this function, another or like that, we're going to see tomorrow.
It's better.
Okay.
Right?
It's better.
So I'm just going to do the example in this one.
I'm going to do it tomorrow.
Okay.
Yeah.
So tomorrow we'll see at the same time, nine o'clock.
Okay.
I'm going to and we're going to do more practice.
Yeah.
Okay.
So see you tomorrow.
It's time.
Okay.
See you tomorrow.
See you tomorrow.
Bye.
Thanks.
Okay.
Okay.
Okay.
Okay.
Okay.
Okay.
Okay.
on 2025-04-02
Visit the Visual Basic for Applications (VBA) for Analysts course recordings page
United Arab Emirates - Visual Basic for Applications (VBA) for Analysts