Excel 2010 VBA Tutorial 103 - Calling Add-In Functions

Official Website: http://yourprogrammingnetwork.co.uk
Forum: http://yourprogrammingnetwork.co.uk/F...
Facebook: https://www.facebook.com/YourProgramm...

---

Closed Caption:

hello and welcome to buy a hundred of
38,000 a tutorial this tutorial is going
to show you how you can reference your
Adam's functions from within other
modules in your vba case and slightly
different to you how you do it normally
say first of all let's just create
ourselves a added say i'm just going to
insert new module I only create a public
function
hi I is not going to have any parameters
and then it's just going to say message
blogs how world that i'm also going to
create one says how personal it's just
going to take a name as a string so just
to show you how do we can pass
parameters as well and that is going to
say hello
username so we've got two functions that
that are going to be usable in our case
then what I want to do is just compile
the project and then save it as an added
so you save as and then we want to save
it hasn't added in
I don't want to save it in my examples
folder
i'm going to save it as a hollow save on
that i'm going to save the xr7 far as
well I'm not going to close its down so
now if we create new work as we save
this as well let's save it my examples
as a microwavable workbook and i'm going
to save it as 200 free copy 2 or X xlsm
I'll was just reading I want to
exon 7 final this press save that blue
bed ads are added so browse select so i
did so how are added and then press ok
I'm gonna go around it and so now we go
into our editor in our new in our new
file we've got dressed nothing in that
agreement because it's just blank and
that in our module over here we've got
our functions that we're going to use so
in here that said she what I just want
to cool one of the functions so let's do
sub cool
sup cool my functions the first of all
i'm going to call the helloworld what's
listed cool i'd normally just type the
how I because that's what the function
is but what you will know us is that if
I press play and it's going to say it's
not to find because it can't actually
see the ones in here despite the fact
that public so what we need to do is
instead of using the cool we're going to
use application . broad and then we'll
pass it how i underscore added thought
XL air and then we press play
oh right price ! and then the name of
our procedure and then we press play and
it's going to run our hello world
so that's how you run a procedure being
added it just is that of cool
applications of blood
you can also pass parameters across
let's do it over once the application
got run and then how do i I do
thought I said I am ! how I was like oh
let's let's just check my personal I
then through a cover and then you see
you go all of these different argument
problems that you can pass through
application . rod so argument one we
just want to be the name so i will put
my name which is matt say that's press
play now it's going to come with hello
world at that how about say that is how
you would cool function from a added
that already exists that's going to be
it for this tutorial with the next
tutorial I'll show you how you would
reference of a world books or worksheet
so thanks for this that I don't catch
suit