Pop-up Calendar Add-In

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details including complete VBA code used in the current video you can visit our website:
http://www.familycomputerclub.com/pop...
1. We embed a calendar control in a userform and code it
2. Next we code the userform during its initialization process. This creates a context menu item called 'insert date' when the user right-clicks on a worksheet ceel
3. On clicking 'insert date' menu item the calendar pops-up
4. Now the calendar shows today's date. However, if the worksheet activecell already contains a date, it displays the date.
5. On clicking a date on the calendar the date is inserted into the active cell and the calendar closes
6. Our code clears the memory of any commands used during the process so that computer memory is freed for other work
7. Now we can save the file as 'macro-enabled' workbook.
To create an add-in which can be used by all workbooks to enter dates quickly and easily we
a. Click on File, Info, properties and finally select advanced properties. In the advanced properties under the item Summary we provide a title of of our choice and next to comments we write a short description.
b. Save the file
c. Finally we save the file as an 'Excel Add-in' file with '*.xlam' extension
d. We click on File and select options
e. In the Excel Options window we select 'Add-ins'
f. Under the inactive add-ins we can see our 'Pop-up Calendar' title and the short description
g. We click on 'Go..' next to manage with the selection 'Excel add-ins'
h. In the window that pops-up we check our 'Pop-up Calender' and click Ok
i. The add-in now appears in the 'activated' area of the Excel Options under Add-ins
j. Now this add-in is available to all workbooks for dates entries!