Build a Pop-up Calendar for Excel #1

Part 1 of 3 tutorials. This video introduces the project and shows you the finished calendar. A good introduction to building VBA UserForms in Excel.

---

Closed Caption:

this is the first of a short series of
demonstrations in which i'm going to
show you how to build this pop-up kinda
4xl the demonstrations are designed to
accompany the tutorial in my website at
www.canineheadstart.com i'll remind you
of that web address at the end of this
demo and the purpose of this calendar is
just to make it easy for people to enter
dates in Excel
simply call at the calendar she's a date
and it writes the date into a cell not
restricted to a single cell you can
select a block of cells
i'm going to right click here and choose
insert date from the menu and when I
choose a date
it writes that date into all the
selected cells
I can make a multiple selection of cells
and I'm doing that by holding the ctrl
key down
last i select different cells and this
time I'm not going to use the menu but
instead a keyboard shortcut to call up
the calendar and when I choose the date
it writes the date into all those
selected cells now the calendar and the
menu item and the keyboard shortcut are
all created in vba using the visual
basic editor which you find on the
Developer tab of the ribbon
and you can choose to build your
calendar in a regular workbook which you
could save it as a template if you like
or if you're just going to use the count
yourself you could save it in your
personal macro workbook but if you want
to distribute the counter to other users
the safest and easiest way to do that is
to create an excel add-in and that's
what I've done here let's return to
excel and once we're on the Developer
tab are open the atoms manager and you
can see that included is the pop-up
kinda which has been installed along
with the other atoms that came with
excel and when the adhan is selected you
can see a short description of its
functions here at the bottom
how do you do all that using vba coding
in the visual basic editor and that
concludes this short introduction in the
next part are start building the
calendar and writing the code and just a
reminder of the web address for the
tutorial
that's www.absongs.com and if you go
there you'll be able to see not only
this tutorial but numerous other
tutorials on excel and access and vba
programming