Date picker : Popup Calendar for Excel

Рет қаралды 300,085

8 жыл бұрын

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

@Too_reel 5 жыл бұрын

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.

@bobmoravec2593 7 жыл бұрын

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.

@sexygranny09 7 жыл бұрын

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.

@raizen8611 5 жыл бұрын

Perfect guide, i am a complete newbie but i managed it like a pro with this video :) Thank you !

@Up4Excel 2 жыл бұрын

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.

@merlin2707 7 жыл бұрын

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

@lsasi4222 7 жыл бұрын

Awesome !!!. Thank you very much for the video. It is very simply explained.

@damaris9242 4 жыл бұрын

Excellent - Thank you. How can I activate the macro by cicking on the cell? Tutorial for that?

@InspirationsMarketing 7 жыл бұрын

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?

@mountasserblom3430 6 жыл бұрын

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 ?

@karthikvijaysomasundaram2291 8 жыл бұрын

thank you dude......looking forward like this tut...

@nicksshaw5199 5 жыл бұрын

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.

@anandkrs58625 7 жыл бұрын

how to add function button to go a month back or year back or forward

@Kanuck12 7 жыл бұрын

Excellent Tutorial! Thanks

@johnty661 8 жыл бұрын

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.

@linawinny3743 4 жыл бұрын

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?

@alpeshshah5802 8 жыл бұрын

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.

@hansahalai3812 4 ай бұрын

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.

@jamessmith-hi1rr 6 жыл бұрын

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

@rickhunter7257 5 жыл бұрын

Thank You for sharing this! You are a superstar!!!

@ExceltoExcelE 5 жыл бұрын

thanks for watching the video and sharing your comments.

@brahmanaspatishastri3320 7 жыл бұрын

Excellent tool! Thanks for the post. :)

@ExceltoExcelE 7 жыл бұрын

Thanks for your feedback, I am glad that you enjoyed the post.

@KA-vx2xs 6 жыл бұрын

Excellent video, explained very nicely. Thanks

@ExceltoExcelE 6 жыл бұрын

many thanks for watching the video and your feedback. Stay in tune...

@pradipk.887 7 жыл бұрын

Thanks for nice tips.

@ngoctunguyen4296 7 жыл бұрын

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.

@michaellopez3231 4 жыл бұрын

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?

@alainsabbagh 5 жыл бұрын

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

@lmarie724 6 жыл бұрын

Great video and so helpful!

@ExceltoExcelE 6 жыл бұрын

Many thanks for your feedback. stay tuned in.

@Taiwanduke 6 жыл бұрын

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!

@leslyjuarez4967 6 жыл бұрын

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?

@diannedrechsler4792 6 жыл бұрын

Very useful, thank you!

@ExceltoExcelE 6 жыл бұрын

Many thanks Dianne for your comments, do subscribe, share and stay in tune

@munasheandrewmuzava9215 7 жыл бұрын

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.

@kevinhughes3607 6 жыл бұрын

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?

@parapack1971 5 жыл бұрын

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

@cata5407 4 жыл бұрын

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?

@haydeesantos1206 7 жыл бұрын

Excelente.. te entendí todo.. y me salio muy bien...

@ExceltoExcelE 7 жыл бұрын

many thanks for the feedback, I am glad it was useful for you.

@patkartarun 4 жыл бұрын

This Solutions rocks, Thanks a lot sir.

@ExceltoExcelE 4 жыл бұрын

Keep watching

@TheManjunathcv 6 жыл бұрын

I am unable to fine month view control

@oakley7 8 жыл бұрын

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

@Goddrikk 7 жыл бұрын

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.

@lesterk6608 7 жыл бұрын

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

@ronb8450 7 жыл бұрын

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.

@stevenandry5122 7 жыл бұрын

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?

@sandragosser1493 4 жыл бұрын

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

@zalilachot4457 7 жыл бұрын

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

@jonasabile2559 4 жыл бұрын

there is no monthly vie control in my option

@MarifeMontemayor 7 жыл бұрын

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" .

@GledistonBastos 5 жыл бұрын

It's amazing. thanks

@brandimills585 5 жыл бұрын

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.

@sandeepdasgupta43 3 жыл бұрын

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

@kyreswim 7 жыл бұрын

To those who cannot find the Month View Control inside Additional Control, try the fix from kzfaq.info/get/bejne/mpmKjNNqrJarcXU.html. It works for me. Please like so that everyone can see.

@sathyanarayanansatagopan9069 2 жыл бұрын

Thank You! Please explain how to pick and drop data in a cell in excel to another cell.

@astuize 7 жыл бұрын

Fantastic !!

@rajeevranjan2478 3 жыл бұрын

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.

@unofficialwork7316 6 жыл бұрын

MS monthview Calender not showing in addional control plz help

@therealpakistan4118 6 жыл бұрын

Super duper Well done bro

@ExceltoExcelE 6 жыл бұрын

Many thanks for your kind words Muzammil. I am glad that you enjoyed. Stay in tune.

@yasminhamdyelsayed7433 7 жыл бұрын

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?

@francktalla6714 5 жыл бұрын

I don't see the command "calendar" in EXCEL 2016

@katherinehughey2022 6 жыл бұрын

I like your videos but they are fast, can you also supply a link with your complete instructions?

@spnn4s106 2 жыл бұрын

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!

@upgradetechnicalskills3392 4 жыл бұрын

Hi, Month over view is not available at 2016

@drsheikh 7 жыл бұрын

Why wouldn't X close the calendar?

@1974fugitive 3 жыл бұрын

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

@jelajahsebanten 2 жыл бұрын

Good sharing

@ExceltoExcelE 2 жыл бұрын

Thanks for visiting

@mohammadfilzamaulanaf4354 5 жыл бұрын

how to change mm/dd/yy to dd/mm/yy?

@gab7340 11 ай бұрын

I don't have Monthly control additional options in vba

@ExceltoExcelE 11 ай бұрын

Strange...

@user-rd7gd4xk3n 2 жыл бұрын

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

@samuelchannel4737 5 жыл бұрын

Cool

@seymourtompkins 3 жыл бұрын

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.

@tajulislam7286 2 жыл бұрын

Wow

@ExceltoExcelE 2 жыл бұрын

@MeIn321 7 жыл бұрын

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.