How to install the Datepicker on your worksheet
How to have a calendar from a drop-down list.
See also how to install the date picker in two columns
How to have your date picker stay in one place after it is saved.
For more help visit my website
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
Here is the code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Sheet1.DTPicker1
.Height = 20
.Width = 20
If Not Intersect(Target, Range(“D3”)) Is Nothing Then
.Visible = True
.Top = Target.Top
.Left = Target.Offset(0, 1).Left
.LinkedCell = Target.Address
Else
.Visible = False
End If
End With
End Sub
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Should make clear from the start this is not available on 64 bit Excel.
Thank you!
mine won't insert. It says, "cannot insert object".
Thnx
Better than before ……one
Hello, thank you for video,
after some time when i pick up the date, the time is also coming. how to solve it?
I didn't seen microsoft date and time picker option in Excel 2016
i can't see MS Date and time picker control 6.0 ( SP4) i use exal-2013 , how can i see that
Can you tell us how to use this when there is no date picker when using a later version of Excel ie. 365??
Hi Barb – tell me. Can I do this in excel 2016 running of 64bit ? I spent all day downloading, installing, registering etc etc and the date picker just doesn't show up in insert >more controls! how do I get this done?
Thanks Ms. Henderson,How do I change date format in the date picker?I have yyyy/mm/dd and I want dd/mmm/yr?
Hi. Can you please print the entire code so I can copy and paste.
Works good except if I select an entire row that has a date picker within it someplace, I get a Run-time error '1004': Application-defined or object-defined error. When I select debug, it highlights the following, ".Left = Target.Offset (0, 1).Left". Please help. I have been struggling with this sheet that I am trying to set up for weeks. I would have never guessed that such a simple task could be so frustrating. Thank you for any help you can provide!
I am facing error code 424
Bonjour, je trouve très intéressante ce tuto. Mais moi mon Excel 2016 n'a pas MiscrosftDate and Time Picker control 6.0 (SP6) comment je peut faire pour l'installer?
When i go to change a already set date it gives me an error.
The error is: Run-time error '440': Invalid property value.
And why i it showing me the time?
Thank you for your feedback
I get an error when I try to go back to cell to change the date.
I have installed the date picker on a bunch of computers for a pop up calendar I built into a spreadsheet. However, weeks later, the pop up calendar is now not appearing and the date picker tool is not in excel. So then I have to reinstall. How do I avoid this? Is there another way to do a pop up calendar than using the date picker?
I wish I had seen this sooner! I watched a few others from other people and got frustrated. Yours was exactly what I was looking for! Thank you!!
This seems to be the best solution. The only thing I dont like is the error I get if you select the cell and with other cells
Thank you Barb, this is great! Is there a way to change the format of the date? right now it shows as "m/d/yyyy" and i would prefer it to simply show "m/d". Thanks!
This is exactly what I needed!!Now how would you do the same to range of cells?For example; I have 2 Columns ranging from B2 to B16 and the same on C2 to C16..Do you do them individually? How?Your help is greatly appreciated!!!
I'm getting an error when I do this. When I type in 'if not' I'm getting an error saying 'complie error.' Please can you help?