Excel 2013 Video 10 Insert a Calendar Datepicker in a Floating VBA Userform

VISIT MY CHANNEL AND SUBSCRIBE FOR MORE INTERESTING EXCEL VIDEOS !

- PHD in Economy ;
- Certifyed Public Accountant ;
- Auditor ;
- 2 Years Master Degree in Tax Law ;

I have many years of experience in :
- Accounting ;
- Taxes declarations for Individual, Limited and Corporations ;
- Balance Sheet, Income Statement and Cash flow Statement preparation ;
- Merger and Acquisitions, Leveraged Buyout ;
- Financial Analysis, Financial Mathematics, Market Analysis.

- Im in search of job opportunities in Canada and in Asia if you are
interested email me at this address nicezz@wooow.it

---

Closed Caption:

hello people did you have found yourself
in a situation like this one here in
this table we have some data and we want
to insert some dates inside a common it
is a very tedious process and when we
accomplish it the possibility of making
some headers entitled the dates is very
I there is a system that we can use to
simplify that process and the at the
same time reduced to almost zero the
possibility of doing an error
the solution is to take advantage of the
presence of a particular contour that is
inside the excel and we insert that
control inside the a new cell phone and
then we have some very simple line of
code will activate it when needed
so let's switch to the the better pair
that with the VBA editor
well II select the Developer tab go to
be 12 basic inside the knowledge of the
project Explorer window identify the
workbook in which you're not working
then right click on it go to the insect
insect user form when the user forum is
a
inserted usually the tool box should
appear also but if it does not appear
like in this case go to the View menu
then click toolbox
well the to control that we won through
that we want is the is not inside the is
not between the default controls of the
the toolbox
we have to in to you need to add to add
each to them and do this right-click
inside the tool box click on additional
chronicles the additional controls
window scroll down until you find the
microsoft mount view condo selected and
then click ok now the content of that we
want it is inside that box and we can
selected click need to select it then go
to or the userform find a good position
for the counter and then you can insert
it no matter our you stretch the counter
it has fix it dimensions
at this point we can besides the
userform then we make a little room at
the bottom of the userform so we can
the
up at encanto click on the button
control and then insert it inside the
user from at this point that we can
close the toolbox
now we have to change the names of this
object in something something that is
more meaningful
first we change we change the name of
the user forum to that then we change
the caption command that then select the
comment button and then we change the
caption to close
now we are ready to insert the very
simple vba code that we make is this
thing
active select the user for then really
care for me
select the color in that condo and then
i click on eat and then this beautiful
this is the subroutine which of the
a date click event of the calendar icon
term inside this little suburb in time
this single line of code
ok now we select we double click on the
name of the user forum and then we
select the button canto and i click on
eat this view called in and then we and
then we can tie another single line of
cold
this line we close the the userform when
it is open it is open it inside
suspension ok now the last team to do
yet inside the VBA editor is to create a
comment that we can
activate when we are inside the the
spreadsheet and to do this select inside
the project is . we will select the the
name select the the double the watch
that workbook enrich rocky and then go
to get you set and then inset module we
can change the name of the module this
way then click inside the code window of
the module and then tie this simple
subroutine by the name of the user forum
show and then we insert false this
little false
at the end of the Cold line doesn't
magic
it makes our or userform floating inside
this page
let me show you how it works to take at
the the userform i recommend you to
attach the macro that opens eat
you are a quick cuts access toolbar icon
and to do this go to find options
quick access toolbar macros
select the market that will open the
user forum and then add it to the quick
access
but then we move in a better position
and then we create we give to this miss
Markham a nice condom like this one
very nice ok so you can see
ok to confer then every time we press
this legal
I can help here the our calendar
PS and we can select the said which we
want to insert the beach and then press
the beat inside the coming that we can
change the amount we can also change the
here and this very external external
because with the userform activated we
can we can create a new watch it and
start to work and in certain dates
inside this in your workshop and move
between the workshop with the userform
activate
isn't that amazing when you were when
you want to close the the user from just
just use the usual common techniques or
just use the clothes
so this is uneven
tutorial it easy as you can see is very
simple because i love simple solutions
and hope you like it
thanks for watching and hope to see you
in the next video