Date picker : Popup Calendar for Excel
Вставка
- Опубліковано 4 жов 2024
- One of the biggest problems in maintaining "good" data is the entry of dates. People seem to get confused about entering dates. Should they enter dd/mm/yy or mm/dd/yy? Do they enter slashes or dashes or dots? And what was the date of the third Thursday in September last year anyway? What you really need is a calendar!
Use an Excel Calendar control or Date Picker to fill in dates.
Finally, after 18 videos, I found one that was easy to follow and the tool actually works.
Thanks for watching the video, stay in touch and don't forget to subscribe for more such videos.
Good comprehensive tutorial on creating this date picker calendar. Thanks for the demo 👍
Glad it was helpful! I am so happy that you liked the video.
Thank you for your excellent directions. I was able to successfully build an Excel macro for the first time, and built this great time-saving feature. Thanks again. Great job.
Perfect guide, i am a complete newbie but i managed it like a pro with this video :) Thank you !
Thank you for an excellent video. I viewed many videos to rectify my problem and not being able to add an add-in on the company laptop, this was the simplest method. 🙌
Fantastic! I am so happy that it helped! Thanks alot for your note.
Far neater than Date and Time Picker control. Great help thanks
I am happy that you found it useful.
How do we add the MonthView Control? Thanks.
Awesome !!!. Thank you very much for the video. It is very simply explained.
Super easy and very detailed instructions, thanks for your help. I am going to subscribe!
Thanks alot for your interest and visiting the channel. Stay tuned.
Excellent video, explained very nicely. Thanks
many thanks for watching the video and your feedback. Stay in tune...
Thank You for sharing this! You are a superstar!!!
thanks for watching the video and sharing your comments.
This Solutions rocks, Thanks a lot sir.
Keep watching
Excellent tool! Thanks for the post. :)
Thanks for your feedback, I am glad that you enjoyed the post.
Really nice, Perfect guide thank you so much
Thank you for watching the video. I am glad that it was useful and you liked it. Stay in tune for more such videos
Thanks a lot, i have been looking for such a tool long
thanks for your feedback, I am glad that video has been useful for you.
thank you dude......looking forward like this tut...
Thanks a lot, it's really simple example to make it works! :D
I am glad that it helped, thank you for your kind words.
Great video and so helpful!
Many thanks for your feedback. stay tuned in.
Thank you sir
So nice of you, Thanks a lot for watching the video ,comments and sharing your experience. It means a lot to me. Please do not forget to subscribe the channel to access more such videos.
Excellent Tutorial! Thanks
Excelente.. te entendí todo.. y me salio muy bien...
many thanks for the feedback, I am glad it was useful for you.
Thank you sooo much. I tried doing this with some other videos but were extremely confusing. Thank you for simple and quick instruction. It worked for me.
Thank You! Please explain how to pick and drop data in a cell in excel to another cell.
Very slick. The video is nice and easy to understand. Can you tell us how to make the calendar close as soon as the date is selected? That would be nice. Thanks
Thanks for nice tips.
Very useful, thank you!
Many thanks Dianne for your comments, do subscribe, share and stay in tune
Excellent - Thank you.
How can I activate the macro by cicking on the cell? Tutorial for that?
I am unable to fine month view control
Doesn't work for me...followed step by step but everytime i run the macro in excel it takes me back to the macro coding and it's word for word what you have typed
I Appreciate Your Hard Work ..... But the saddest part is my VBA UserForm toolbar is not showing the Calendar toolbar .... Can U pls help... how to get the Calendar tool
there is no monthly vie control in my option
Everyone is having the same problem with the MonthView Control.. Missing from the latest version of Excel.. Any help with resolving this issue?
Did you receive a solution to add the MonthView Control?
Great Explanation. Unfortunately, there is no Microsoft Month View in the available control list. I use Microsoft excel 365. Could you help how to add that into the control list?
Suleman, On your initial example you show a calendar that has days of the week however the inbuilt one does not. Please can you explain how to get a more user friendly calendar that you initially showed. Thank you
No need to reply, i have sorted it.
Sorry for delayed feedback, I just saw your comments, apologies.
How did you do this? the calendar with days of the week
Thanks so much. Very useful. Tell me why does the Macro spreadsheet open every time I activate the calendar? Does the other spreadsheet always have to be open for the Calendar pop up to work?
Hello. I can´t use Microsoft Month View Control, I just have Microsoft Outlook Date Control. I try to run it but it can´t. Can you please help me?
this was excellent...do more...such as 'how would clicking on a cell activate or pull up the Calender ?"
Noted for future videos. Thanks for the note and watching the video.
Super duper
Well done bro
Many thanks for your kind words Muzammil. I am glad that you enjoyed. Stay in tune.
I can't see the MonthView Control. I am using Microsoft Office 365. Please help. :(
Right hand click on tool box and choose additional control. Tick the "Microsoft Month View Control" .
Good sharing
Thanks for visiting
Great spent hours trying to use date picker nightmare this is far easier can I ask if I want to send a spreadsheet to a colleague to use with this macro how do I embed the macro into the sheet? Thanks Again
Hello, I was able to go to the 'Additional Control' list but my problem is that I am not able to see the 'MSFT MonthView Control 6.0'. Any advice how to download/unable this tool?
Thank you for sharing this valuable tool.
I have same problem. Any help? Any one?
would it be possible to tell me which version of office you are using? it is possible that maybe it is appearing with a different name there...
would it be possible to tell me which version of office you are using? I will figure it out, it is possible that maybe it is appearing with a different name there...
I am using Excel 2016 (Subscription Product - MS Office 365).
Same here. I'm using Excel 2013
Thank you very much for your helpful video. Just one more questions, Is it possible to set a range on the dates you want to select ? So lets say a range from 2018-2019 ?
It's amazing. thanks
Hello. Thank you very much for your valuable contribution.
When I send the excel file to other colleagues with office 2016.
The calendar generates an error in your pcs and takes them to visual basic.
What can I do so that this does not happen
I like your videos but they are fast, can you also supply a link with your complete instructions?
how to add function button to go a month back or year back or forward
I don't see the command "calendar" in EXCEL 2016
I got this to work but my original XLSM file that i saved the macro in opens each time i use the macro in another spreadsheet? what did i do wrong?
To those who cannot find the Month View Control inside Additional Control, try the fix from ua-cam.com/video/d3ZYp9G0GAA/v-deo.html. It works for me. Please like so that everyone can see.
Hi, Month over view is not available at 2016
I don't have the form builder option in Visual Basic. How do I get this? I also see that my toolbox is shaded and I can't click on it. Am I missing something?
hello I was able to do everything you mentioned in this video but at the end I got error please advise. what to do next to resolve this error. thank you.
Fantastic !!
Thanks for your simple explanation but really helpful. It worked for me.
But I found that everytime I use the macro from the ribbon in another excel file, automatically MacroCalendar.xlsm pop-up as well. Is this something normal?
well it is pretty common and there is a solution for this you can add following at the end of your code and it should stop showing the macro file for you.
Windows("filename.xlsm").Visible = False
So in file name above you can add your macro's file name
I hope it helps
cheers
Hello. Got the same problem. Sorry, didn't understand - where should I write this command?
having the same problem. were do i put this code?
Hey guys got it sorted. Go to the Module 1 and double click and under the other code: UserForm1.show False; write Windows("yourfilename.xlsm").Visible = False and save it then the file wont open again. :) Hope that helps
Question, I have this problem with the Month Viewer control is not in excel 2016. I'm having issues on finding a way to make this pop up calendar. Do you have a suggestion on how I can do this or get the additional control?
Hi, thanks for your question, I am not sure about it, let me check and get back to you on this.
I don't have Monthly control additional options in vba
Strange...
wondering if there is a way I can export my outlook calendar into Excel so I can see al my weekly and bi-weekly meetings and make a meeting cadence spreadsheet.
There are multiple ways to do that. I will produce and explain it in a separate video. Please stay in touch
@@ExceltoExcelE Perfect! Thank you SO much!
Hello Suleman, I have done everything as you tought but at the end I always get the same error massage
"Run time error '-2147220995 (800401fd)':
Automation error
Object is not connected to server"
What is the problem here? I really want to use this add-on, thanks for your help!
MS monthview Calender not showing in addional control plz help
Why wouldn't X close the calendar?
What if I do not have Microsoft MonthView Control in my "Additional Controls" list? I use Microsoft 365.
It's very strange because I believe that it is supposed to be there by all means
What to do, if I don’t see monthly calendar control in the toolbox?
Possible because as I understand mscal.ocx (Calendar Control) does not exist in al Excel versions, which version are you using?
@@ExceltoExcelE 2016
Strange... Should work well with 2016
Would somebody be able to tell me how to change the date format? I can't format the cell like I normally would to chose my date format. Is it even possible to do so?
In the beginning of your video, on the calendar that pops up, you can see the days of the week at the top of the calendar. On the clip at the end, you cannot see them and when i followed these steps the days of the week were not there. Is there a way to get those to show?
You can customize calendar and can change order of days of the week at top too. On calendar properties under show days make it true. You will able to see days on top.
how to change mm/dd/yy to dd/mm/yy?
thanks a lot, but i repeated it many times and the same problem appears , the calendar appear but when i press the date does not appear in the active cell, as i do not have a microsoft date picker i am using control date , is it right ?
hi Yasmin, which version of office you are using?
Hi. Will this work when I open the work book on another machine running excel, possibly 64bit ?
Thanks
Though did not try but should not have any issues with 64bit machine.
Cool
Sorry, but this demonstration went way too fast for somebody who's skills in Excell are minimal. After following the tutorial, my calendar never appeared on my spreadsheet. Frustrating!
thanks for your comments Timothy, your feedback is much appreciated and noted for future sessions.
Wow
:)
D
you move your mouse around too much very annoying trying to follow
Talk way to much. Just need the steps, thank you