WEBVTT

00:02.140 --> 00:02.920
Okay guys.

00:02.920 --> 00:03.970
And welcome back.

00:04.120 --> 00:09.580
Now so far the couple of examples so we've had a look at function pie spelt incorrectly and function

00:09.580 --> 00:10.300
Square.

00:10.300 --> 00:18.640
We both do calculations but you can easily you see a UGF user defined function to use to pull some data

00:18.700 --> 00:20.650
about the spreadsheet that youre working in.

00:20.770 --> 00:26.460
Now what to do here is I'm going to create another function the save function.

00:26.500 --> 00:30.040
Where is this file.

00:30.490 --> 00:35.780
And I don't need to specify any parameters between the between the brackets here.

00:35.830 --> 00:40.870
So one thing to say is here and then copy that because that's the return value.

00:41.120 --> 00:44.120
And I say where is this file equals.

00:44.140 --> 00:54.340
And I will say this work book Darte path and you can find a load of these different things in the macro

00:54.340 --> 00:55.650
book section.

00:55.780 --> 01:00.400
There's an there's loads of different things like find in the user find in the name of the file all

01:00.400 --> 01:01.900
kinds of things in there.

01:01.910 --> 01:10.030
So now let me just delete all of them if here I say equals where you can see where is this file has

01:10.030 --> 01:12.730
been added here as a user defined function.

01:12.770 --> 01:16.430
It's just going to hit the tab closer brackets and when I hit enter.

01:16.460 --> 01:23.110
Let me just drag that out so you can see go this particular file lives in my f Dropbox you do me excel

01:23.110 --> 01:26.010
level three VBA program in slash complete.

01:26.050 --> 01:32.140
So they go you don't have to use a calculation you can use a custom function user defined function to

01:32.140 --> 01:33.810
return information.

01:33.880 --> 01:35.750
Okay I'll see you in the next one.

01:35.770 --> 01:38.670
We're going to have a look at doing something a little more complicated.

01:38.740 --> 01:40.030
I'll see you there.
