Click on a celFor l to select an input calendar. Select a date from a calendar by just click on the cell. Bring up a pop-up calendar by just click on a cell.
here is a link for installing the calendar on the toolbox
For more help visit my website or email me at
easyexcelanswers@gmail.com
I am able to provide online help on your computer for a reasonable rate.
MY videos are all created on Camtasia.
Follow me on Facebook
MY videos are all created on Camtasia.
Check out my courses
Introduction to Excel
Intermediate Excel
Follow me on Facebook
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Thanks.
My toolbox not show calendar
Thanks Barb – very useful
"opened a user form and then created a calendar"…….how? Big gap there.
Thank you very much, this is a great tutorial !
The command unload.me didn't work for me, I had to use unload me (basically the same but adding a blank instead of the period) and it worked perfectly.
I could not get it to work in Exel 2016, where can I get a written step by step procedure.
Need some help with date picker tool, maybe someone here could give me an answer: I created an excel 2007 (32bit) file with nothing but drop down menu cells and placed the whole worksheet into protected mode, so no cells except the drop down cells can be changed. Then I installed the date picker tool and created a date picker calendar cell which works exactly as it should. When saving the file, I was prompted to save it as a macro enabled file, otherwise the date picker function supposedly doesn't work. So far so good. But when I open the file on another Office 2007 32bit system there is no checkbox alongside the date picker cell, only a crossed square. I also disabled macro security on the second machine, but to no avail. So my question is: do I need to install the DatePicker Tool feature on every machine that is going to work with this Excel file, even though the user is only required to select a date from the calendar?
Thank you for any help you may be able to give!
Thank you for the amazing tutorial. Can you please also share VBA Coding??
Thank you for the easy & clear tutorial.
Thanks Phyllis
Everything nice and well, but where the hell is my calendar in the toolbox, i have 16 things to choose from, all but a calendar :s
I got it to work: I have tried to improve like this in order to get the date picker popup for any cell formatted as Date.:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.NumberFormat = "m/d/yyyy" Then
MyCalendarPicker.Show
End If
End Sub
(I couldn't get it work for all Worksheets using Workbook_SheetChange.)
Also to edit multiple selection I have changed:
Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
Selection = DateClicked
End Sub
One drawback in the Form is that it won't initialize the picker with the original value.
All in all I prefer using https://www.rondebruin.nl/win/addins/datepicker.htm
Very nice video, can we have a link to the excel file Thank you very much