Exporting VBA Script as Add-Ins or Bas-files

After you have created a powerful VBA script in Excel, you may want to use it in other projects or make it available to other users on the network. Do not keep inventing the wheel all the time, so find a way of recycling your code. There are two ways: creating .bas files or add-ins.

---

Closed Caption:

sometimes you have to be a code teach
you want to use in underwear group
or you want other users to you sure crew
duel decks:
keep the inventing do we there are
actually two wage
to recycle your cool in other parts
shipped
diffuse way is to ensuring your Marshall
coach
in the form of a bitch file in the
second method
aced to create an anti which can be
activated in any other clutch
but starfish the fearsome how do you
create a Best Buy
see you have to swallowing shock protein
your Phoebe a
and it how do you open your feet be a
editor
alt F 11 insurance
March I created a very simple
shop dish shop Ishant
dearly and Merkel Merkel runs elites
all dish shop passion documents
so when you call shop
along you have to specify how many
minutes
do you want to go pass by before the
alarm pixie
to share the simple cold I and
which is just too long type is to time
with a timer is two-time
scheck inch since midnight plush
I'm me next time sixty because we're
dealing with scheck its
sure we have to multiply I mean in
spanish 60b course China is
in scheck then review
while timer second since midnight is
still less 10
hi and we don't want to block to system
while decision looping
sure we use to do evens subtlety if
finally when do you push
finished three tell the usual how debt
talks manage
have past see that code ish
so important to rush that we wants to
usage in other pledge so
re right click on the Marshall X 425
ended the screen pops up
and it's going to she stepped as shit
dash type 5
I called it along Da Bears pretend it's
completely up to you
then we use Dept
this file in a new or checked in New
trial a new workbook on another machine
and re you stay at shocking to you that
I call hun
alarm & Shop and be wants to use here
that's best trial so I don't have to
reinvent
to call in the type it in that
left panel p.m. we are going to
right click on this march in and import
batch file this time before we had
exported
and then it will show you this listing
it will show you for all that
dash trials India is alarm
dog best I'm going to open image and
in Portage into deceased know it creates
a new Marshall is probably called
Marshall
11 I he named it to
new Marshall or my alarm Marshall
whatever you want to call by the way if
disclaimed us not
is not available out to magically you
always go to
few properties window and then
in 121 really helps
already cuz I'm along we're going to
call
the airline in the official on
it comes from a new module which was
imported
it the quiet one document instead of
typing
a number of one minutes fifteen minutes
sixty minutes
I'm using an inputbox how many minutes
to your arms
to let go by by default I do one
in a national one
minute it will tell us that one minutes
has passed
don't wish
message to one do
nada mas addition and I think will
explain later works
it the trend each might be fusion at in
of a bitch fight nationalisation book
and you can give ten best friend to
anyone you can keep it on
your network show others can always call
it any time they needed
so we're going to create an heading in a
new world
this is going to become our at it
its to seem shocking teen as we
discussed before
edition Marshall I made sure that I have
only one sheet
in this project so if you have more she
each
I would delete the other ones for dr.
completely empty we are going to use
diskpart checked only
for and in pure which
then we compile the alarm headin d-block
on trial alarm Eddie it's that
exigent run faster
you rename it
view property shift is window is not
open
and we are going to shave that whole
part shipped
yes an Excel at in
expel a M
in each doorsteps in Microsoft
edits true all the Edensor collected
together
to know we open and you know we're
broken apart checked whatever you call
it
and full trial options we go to the
Athens tap
you will see dats yet these are all in
active
Haddin's at this moment my sister
so we are going to click on call to
activated
when you click Tia it to open up this
little dialogue box
and one st at in-state you have to
check on his alone
once we click on OK we will find it in
GV
editor as a new
added when I selected in
and I go to the option browser
object arms race dish but in case you
are
and i'm looking to library alarm headin
I see it s 11 chill one she each
this workbook and it only has one member
alone this could be many many other
message when you click on long it will
show you at the bottom
what dat function were shot 14 Dutch
however when we are going to it
lunar module 2i will project where we
want to use that
headin I call it shock text-align:
I start typing ho-hum it does not pop
rock
in my options listing why not
be karsh we haven't and its debt
to GBA section yet
you go to tools references
and make sure that your alarm head in is
checked
on at the moment you do dat
you will find it to you as a new section
reference to
alone Excel a.m. India his own Excel
a.m. show no I can just call
alone again like we did before
you a very shy cling your alone called
when you see a twenty children and teens
call from best trial
if you ever decide to change your
fiction
file your alone headin on the network
your computer all the changes will out a
medically take affect
if you ever change best value have to
exploded again
important again everyone has to do it
was going to use it
it and initiate randy said it
automatically takes effect astonished
ed initial network you just replace the
old one which two new
however be away here date read can I
change
parameters so if you decide that you
want to share compared to a model for a
while
not only did not know minutes but also
do you want to be a rooted yes or no
what do you want to do when the alarm
goes off don't
scheck an argument between re implement
its
dish shocking teen we only use one
argument
so it will run into trouble because it
says I need an argument
unless you made it option
so here and the two different we ship
recycling your code
we discussed extensively I think
its different way should doing things
between member to second way
sth ain't each to teach easier to update
otherwise it doesn't really matter which
way you go
you want to know much more about Visual
Basic
each my fish power show created a CD-rom
gold excel 2007 GBA
which can also be used to function 10
2040
it has 3 charge each practice more than
try from dirt sly each
fairly extensive here to stay issue we
discussed
Indische radio you want to know much
more about
PBA whether she will be fairly limited
using GV
I developed teachings you can find him
interesting Excel dot com
or Genesis peachy dot com
and my name is Joe factual issue wish
you good luck
we fictional she be