SUPER helpful. The only thing I would edit is the location of the date pick when it appears. When it is so close to the cell, it hides the drag function of that cell. A quick fix is to put a "1.5 x cell width" in the code to offset the date picker just a bit.
Amazing. Thank you so much for this very useful tip indeed. I have been searching exactly for this type of cell behavior for ages. All I got was garbage till now. Thanks again, much appreciated.
Totally on board - until the very end when you tell us that it wont work unless the macro is installed on every PC that will be using this. Why did you wait to state this? Kind of important right up front - no?
Thank you very much for your great video. Would you mind sharing with us how to highlight the date which already been filled in the popup calendar? I tried to use the Highlight Range of Dates option but it seems to highlight a fixed value or range instead of a dynamic one as the mouse-selected cell.
Hi, this is awesome work. I just found you on my RUclips feed but i am happy i did. I am beginner freelancer with exxel being my tool of business. This video is super useful
Hey, Thanks for the big help! Really appreciate it! But I would like to share that if I try to change the date format in the code, it doesn't work. Can you please resolve it?!
Hi . this is a a great fix. I have a workbook with about 30 worksheets. Anyway to edit the code so I can put in into the workbook once, without having to edit every single sheet?
![Stromae, Pomme - “Ma Meilleure Ennemie” (from Arcane Season 2) [Official Visualizer]](http://i.ytimg.com/vi/1F3OGIFnW1k/mqdefault.jpg)
Excel for web comment was what I was looking for - timesaver! Thank you - Subscribed!
Insanely helpful! This is like the only useful vid on Date Picker thing I could find on RUclips
BRILLIANT! I WAS SO DESPRATE BECAUSE I COULDNT DO THIS, BUT YOU SAVED ME THANK YOU SO MUCH
SUPER helpful. The only thing I would edit is the location of the date pick when it appears. When it is so close to the cell, it hides the drag function of that cell. A quick fix is to put a "1.5 x cell width" in the code to offset the date picker just a bit.
Amazing. Thank you so much for this very useful tip indeed. I have been searching exactly for this type of cell behavior for ages. All I got was garbage till now. Thanks again, much appreciated.
I’ve been trying to figure this out all day, then I found my new best friend 😁 and it’s so cool !! Thank you!!
This is nice, watched other Tutorials and they were good too. This one behaves as i wanted. Thank You for sharing.
Well done. I was looking for this solution everywhere. Only your video provides the required solution. Thank you.
I’m so glad it helped! Have you checked out my free training? www.excelpowerup.com/training 🎉
Totally on board - until the very end when you tell us that it wont work unless the macro is installed on every PC that will be using this. Why did you wait to state this? Kind of important right up front - no?
When I do this on a brand new Workbook, it works. But for workbooks I have already created, it doesn't. Any ideas?
Thank you very much for your great video. Would you mind sharing with us how to highlight the date which already been filled in the popup calendar? I tried to use the Highlight Range of Dates option but it seems to highlight a fixed value or range instead of a dynamic one as the mouse-selected cell.
Hi, this is awesome work. I just found you on my RUclips feed but i am happy i did. I am beginner freelancer with exxel being my tool of business.
This video is super useful
Thank you for simple but great video. Mine the calendar was default highlight a fixed date so how can I make it highlight on selected date?
And just became a new subscriber. Thanks for the clear and detailed instructions. Going to use this for inventory logs.
That's wonderful! Thank you for subscribing 🙂
Hey, Thanks for the big help! Really appreciate it! But I would like to share that if I try to change the date format in the code, it doesn't work. Can you please resolve it?!
Took me a while to get the code working but, all good... Well done!
Well done to you!!
Do you know how I can change this so the calendar appears to the left of the active cell instead?
Can this be done with multiple columns that aren’t next to each other?
Hi so I did like your video and it worked but only 1 problem, I cant overwrite the date?
Hi, How can you change it to the language of the calendar?
Thank you, Thank you and 100 more. You are so generous with your knowledge.
I am unable to get this macro to work. Could it be because my excel is in another language?
My excel is set to the language of Danish
Does this process work for a mac?
the calendrer opens in a browser instead on excel, any fix you know of?
Can you insert from date picker for multiple cells?
There might be a way to do this with a macro!
Hi . this is a a great fix. I have a workbook with about 30 worksheets. Anyway to edit the code so I can put in into the workbook once, without having to edit every single sheet?
Thanks ! No more waste of time !
Thank you!
How can we use it without the add-in?
Unfortunately that's not possible. Excel hasn't released a calendar feature, so we rely on the add-in!
does not work for me