Video Transcription

00:00

so so far you have seen how we create Mac Rose as a subroutine. Whether we recorded or we type it,

00:09

it's a 17 that can be cold from another 17 or function.

00:14

But now let's create a function

00:17

within Excel using macros, a visual basic.

00:23

This function can be then cold in a cell like any of the other functioned. It exists in visual basic

00:31

that would take a visual basic.

00:35

We go to insert, we have module,

00:38

we select module

00:40

and then we type

00:44

function.

00:48

They're going to call it the oregano, and it's going to have

00:52

all right, number one

00:54

and them, too.

00:58

Parameters

01:02

and dysfunction is going to calculated the agonal off a triangle has one

01:07

right angle. So

01:11

sorry. Straight at the 90 degree angle. So, um,

01:15

it's, um

01:19

yeah, you know

01:21

is equal

01:23

two

01:25

sq r

01:27

off

01:30

them one,

01:34

someone,

01:37

waas

01:38

two.

01:40

Multiply it

01:44

but itself.

01:47

And, uh,

01:51

we just say, like save because this is it.

01:53

It's going to take number one. It's going to multiplied by itself. It's going to add number two multiplied by itself,

02:00

and then it's going to calculate square root of it.

02:07

And when we do this first time get this message which says that

02:13

we cannot save dysfunction

02:15

in a standard X l s X format. We have to save it in a format that supports my crows.

02:23

So we take here or no,

02:25

we get the same file and then here we select type as ex Elice em

02:32

save

02:35

you Close this.

02:37

And now we have

02:38

this module here as ex Ellis M, meaning that it campaigns macros.

02:44

So

02:45

didn't just stay there, Colonel

02:47

and Selectees too.

02:53

And the cantor and we get the number here,

02:57

which is exactly that. So,

02:59

um, just to make sure that

03:02

this is correct, we're going to type here three and four and we get five because it's ah, it's a common knowledge. If you remember your math in high school that to the triangle

03:16

that has to size three and four, the agonal is five.

03:21

So, uh, it's all about

03:23

well, how to create

03:27

Ah, you function.

03:30

And

03:31

what you have seen is also

03:35

that there. And I start typing equals and I just out d I

03:39

You get diagonal. So Excel already has put this function in the list of functions

03:46

and it's there. Andi, also,

03:50

if I go here, insert. Sorry.

03:54

Just this.

03:57

Okay,

03:58

Go into formulas and go to insert function.

04:01

And I say all and I go here.

04:06

It should be in the list.

04:12

Here it is.

04:13

So it's added to the list of all functions

04:16

in excel. So now you know what's the difference between sub macro and function macro and how to create one and the other.

04:28

And in, ah, next lesson, I'm going to talk about some other things that you can nicely do

04:35

in macros. Visual Basic.

04:40

So thank you.

Up Next

Intermediate Excel

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel training will help students advance their skills and pass an intermediate Excel exam.

Instructed By

Similar Content