Date picker : Popup Calendar for Excel
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.
Пікірлер: 125
Finally, after 18 videos, I found one that was easy to follow and the tool actually works.
@ExceltoExcelE
3 жыл бұрын
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 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.
Perfect guide, i am a complete newbie but i managed it like a pro with this video :) Thank you !
Good comprehensive tutorial on creating this date picker calendar. Thanks for the demo 👍
@ExceltoExcelE
2 жыл бұрын
Glad it was helpful! I am so happy that you liked the video.
Awesome !!!. Thank you very much for the video. It is very simply explained.
thank you dude......looking forward like this tut...
Super easy and very detailed instructions, thanks for your help. I am going to subscribe!
@ExceltoExcelE
5 жыл бұрын
Thanks alot for your interest and visiting the channel. Stay tuned.
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. 🙌
@ExceltoExcelE
4 ай бұрын
Fantastic! I am so happy that it helped! Thanks alot for your note.
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 ?
Far neater than Date and Time Picker control. Great help thanks
@ExceltoExcelE
8 жыл бұрын
I am happy that you found it useful.
@boxmanboxwoman7406
7 жыл бұрын
How do we add the MonthView Control? Thanks.
Excellent Tutorial! Thanks
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?
Thank You for sharing this! You are a superstar!!!
@ExceltoExcelE
5 жыл бұрын
thanks for watching the video and sharing your comments.
Excellent tool! Thanks for the post. :)
@ExceltoExcelE
7 жыл бұрын
Thanks for your feedback, I am glad that you enjoyed the post.
Excellent - Thank you. How can I activate the macro by cicking on the cell? Tutorial for that?
Thanks a lot, it's really simple example to make it works! :D
@ExceltoExcelE
7 жыл бұрын
I am glad that it helped, thank you for your kind words.
Excellent video, explained very nicely. Thanks
@ExceltoExcelE
6 жыл бұрын
many thanks for watching the video and your feedback. Stay in tune...
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
Great video and so helpful!
@ExceltoExcelE
6 жыл бұрын
Many thanks for your feedback. stay tuned in.
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.
Really nice, Perfect guide thank you so much
@ExceltoExcelE
5 жыл бұрын
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
@ExceltoExcelE
7 жыл бұрын
thanks for your feedback, I am glad that video has been useful for you.
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
Very useful, thank you!
@ExceltoExcelE
6 жыл бұрын
Many thanks Dianne for your comments, do subscribe, share and stay in tune
how to add function button to go a month back or year back or forward
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?
Excelente.. te entendí todo.. y me salio muy bien...
@ExceltoExcelE
7 жыл бұрын
many thanks for the feedback, I am glad it was useful for you.
This Solutions rocks, Thanks a lot sir.
@ExceltoExcelE
4 жыл бұрын
Keep watching
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.
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.
@danieljung1152
8 жыл бұрын
I have same problem. Any help? Any one?
@ExceltoExcelE
8 жыл бұрын
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...
@ExceltoExcelE
8 жыл бұрын
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...
@oakley7
8 жыл бұрын
I am using Excel 2016 (Subscription Product - MS Office 365).
@jadlteif8143
8 жыл бұрын
Same here. I'm using Excel 2013
Fantastic !!
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
@lesterk6608
7 жыл бұрын
No need to reply, i have sorted it.
@ExceltoExcelE
7 жыл бұрын
Sorry for delayed feedback, I just saw your comments, apologies.
@julieannamill6962
7 жыл бұрын
How did you do this? the calendar with days of the week
Thank you sir
@ExceltoExcelE
3 жыл бұрын
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.
I am unable to fine month view control
Thank You! Please explain how to pick and drop data in a cell in excel to another cell.
To those who cannot find the Month View Control inside Additional Control, try the fix from kzread.info/dash/bejne/lmeOu9Jyd5OtcaQ.html. It works for me. Please like so that everyone can see.
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?
Hi. Will this work when I open the work book on another machine running excel, possibly 64bit ? Thanks
@ExceltoExcelE
7 жыл бұрын
Though did not try but should not have any issues with 64bit machine.
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?
Super duper Well done bro
@ExceltoExcelE
6 жыл бұрын
Many thanks for your kind words Muzammil. I am glad that you enjoyed. Stay in tune.
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!
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?
@ExceltoExcelE
7 жыл бұрын
Hi, thanks for your question, I am not sure about it, let me check and get back to you on this.
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?
@ExceltoExcelE
7 жыл бұрын
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
@jurisrudzitis3703
7 жыл бұрын
Hello. Got the same problem. Sorry, didn't understand - where should I write this command?
@julieannamill6962
7 жыл бұрын
having the same problem. were do i put this code?
@InspirationsMarketing
7 жыл бұрын
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
It's amazing. thanks
Everyone is having the same problem with the MonthView Control.. Missing from the latest version of Excel.. Any help with resolving this issue?
@boxmanboxwoman7406
7 жыл бұрын
Did you receive a solution to add the MonthView Control?
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?
there is no monthly vie control in my option
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
I can't see the MonthView Control. I am using Microsoft Office 365. Please help. :(
@nazedyra3167
5 жыл бұрын
Right hand click on tool box and choose additional control. Tick the "Microsoft Month View Control" .
I like your videos but they are fast, can you also supply a link with your complete instructions?
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
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?
@umerj795
5 жыл бұрын
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.
MS monthview Calender not showing in addional control plz help
Hi, Month over view is not available at 2016
I don't see the command "calendar" in EXCEL 2016
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 ?
@ExceltoExcelE
7 жыл бұрын
hi Yasmin, which version of office you are using?
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.
@ExceltoExcelE
2 жыл бұрын
There are multiple ways to do that. I will produce and explain it in a separate video. Please stay in touch
@spnn4s106
2 жыл бұрын
@@ExceltoExcelE Perfect! Thank you SO much!
how to change mm/dd/yy to dd/mm/yy?
What if I do not have Microsoft MonthView Control in my "Additional Controls" list? I use Microsoft 365.
@ExceltoExcelE
2 жыл бұрын
It's very strange because I believe that it is supposed to be there by all means
Good sharing
@ExceltoExcelE
2 жыл бұрын
Thanks for visiting
I don't have Monthly control additional options in vba
@ExceltoExcelE
11 ай бұрын
Strange...
this was excellent...do more...such as 'how would clicking on a cell activate or pull up the Calender ?"
@ExceltoExcelE
2 жыл бұрын
Noted for future videos. Thanks for the note and watching the video.
What to do, if I don’t see monthly calendar control in the toolbox?
@ExceltoExcelE
2 жыл бұрын
Possible because as I understand mscal.ocx (Calendar Control) does not exist in al Excel versions, which version are you using?
@user-rd7gd4xk3n
2 жыл бұрын
@@ExceltoExcelE 2016
@ExceltoExcelE
2 жыл бұрын
Strange... Should work well with 2016
Cool
Wow
@ExceltoExcelE
2 жыл бұрын
:)
D
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!
@ExceltoExcelE
7 жыл бұрын
thanks for your comments Timothy, your feedback is much appreciated and noted for future sessions.
you move your mouse around too much very annoying trying to follow
Talk way to much. Just need the steps, thank you