Date picker : Popup Calendar for Excel
HTML-код
- Опубликовано: 29 авг 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.
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.
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.
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.
Perfect guide, i am a complete newbie but i managed it like a pro with this video :) Thank 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.
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.
This Solutions rocks, Thanks a lot sir.
Keep watching
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 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.
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! Please explain how to pick and drop data in a cell in excel to another cell.
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.
thank you dude......looking forward like this tut...
Great video and so helpful!
Many thanks for your feedback. stay tuned in.
Good sharing
Thanks for visiting
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
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.
Very useful, thank you!
Many thanks Dianne for your comments, do subscribe, share and stay in tune
Thanks for nice tips.
To those who cannot find the Month View Control inside Additional Control, try the fix from ruclips.net/video/d3ZYp9G0GAA/видео.html. It works for me. Please like so that everyone can see.
Excellent - Thank you.
How can I activate the macro by cicking on the cell? Tutorial for that?
there is no monthly vie control in my option
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 am unable to fine month view control
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?
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?
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
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?
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
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?
Super duper
Well done bro
Many thanks for your kind words Muzammil. I am glad that you enjoyed. Stay in tune.
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
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" .
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.
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
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?
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
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
how to add function button to go a month back or year back or forward
Cool
I don't have Monthly control additional options in vba
Strange...
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
I like your videos but they are fast, can you also supply a link with your complete instructions?
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?
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.
Fantastic !!
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!
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.
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.
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!
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.
Hi, Month over view is not available at 2016
I don't see the command "calendar" in EXCEL 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?
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
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
MS monthview Calender not showing in addional control plz help
Why wouldn't X close the calendar?
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?
how to change mm/dd/yy to dd/mm/yy?
Wow
:)
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.
D
you move your mouse around too much very annoying trying to follow
Talk way to much. Just need the steps, thank you