Free pop-up DatePicker for Excel UserForm. simply DragDrop and use

[@johnwhite7927]

I've been beating my head off my desk trying to get everyone in my group to input dates the same way because Microsoft decided to remove support for their Dtpicker and this is exactly what I was looking for. Liked, subscribed and form submitted. Looking forward to getting this and putting this whole date picker headache behind me.

[@VBAA2Z]

Thank you for your support. Please check spam folder too

[@ayoubbakkari7709]

this is my best VBA youtube chanel

[@VBAA2Z]

Thanks!

[@MrScarymaster]

I've been following your work over the past 4-5 years or so. You've inspired me so much and just wanted to thank for that! I hope you did not stop producing these videos and more will come in the future!! Thanks again

[@VBAA2Z]

Thank you so much for your kind words and support! I truly appreciate your continued following and I'm thrilled to hear that I've been able help. Rest assured, I have no plans to stop creating videos. In fact, I have many exciting ideas and content lined up for the future! Stay tuned and keep an eye out for more videos coming your way. Thank you once again for your encouragement and for being a valued fan.

[@dxfvgyhjh]

I found a little bug, if you try to switch only year without switching month (e.g. feb 2021 to feb 2022) you can modify manually the year but to select a day of that same month you have to select an alternative month before then reopen the months list and reselect the orignal one otherwise the list won't disappear. Adding the capability to select the preselected month and an after/before button for years would make this date picker very close to perfection bc writing them slows workflow since they aren't usually that far in selection. (for bills, deadlines etc.) Really just one click to go one year back or ahead. Admirable work anyways, you're fantastic. Subscribed.

[@VBAA2Z]

Thanks Satoshi Nakamoto for sharing your observation and for your support. I will review and post back this week.

[@nguyenjack4067]

What a wonderful works!!! It's been a long long time since I found a quality VBA channel like yours.

[@VBAA2Z]

Glad you enjoy it! thanks

[@mahensolanki8972]

Have been looking for this from a long time. Thanks.

[@VBAA2Z]

Glad to help

[@ronedwardyap6940]

Do you download it?

[@PeterChambers-gb4bk]

Exactly what I have been looking for to input dates into a user form

[@VBAA2Z]

good to hear

[@lilynewmai8314]

Appreciate you for sharing all these useful tools. Keep up the great work.

[@VBAA2Z]

My pleasure!

[@MuhammadShahAlam99]

Outstanding!!! Excellent👍 One of the best date picker❤️❤️

[@VBAA2Z]

Thank you kindly!

[@hardyharry7223]

Superb Buddy, This is what i was searching from long long time.

[@VBAA2Z]

Great!

[@王大蠻-d1z]

Very helpful video. thanks for sharing.

[@VBAA2Z]

Glad it was helpful!

[@pedche5790]

excellent video and tool. thanks for sharing it freely.

[@VBAA2Z]

Glad it was helpful!

[@madhurimotamarri6571]

Amazing Tutorial - Just filled out the google form for it

[@VBAA2Z]

Thanks Madhuri.

[@mvining7]

This looks like just the tool I've been searching for! Thank you for your content.

[@VBAA2Z]

You're very welcome!

[@Andesiteable]

Cool popup will be using in my user form!

[@VBAA2Z]

thanks!

[@ravindrapatel4591]

Excellent work done for new to Excel VBA.

[@VBAA2Z]

Glad you think so! thanks for watching.

[@jovannijabat2004]

great tutorials.. looking forward to learn and buy some great tools.. thanks.

[@VBAA2Z]

Awesome, thank you!

[@olamikusholabi3247]

Nice Video...a life saver....Thank you so much for this.

[@VBAA2Z]

Glad it helped!

[@cgd1037]

Great content thanks for filling a gap for 64bit calendars.

[@VBAA2Z]

thanks!

[@deetemple1]

Simplicity is power. Thanx!

[@VBAA2Z]

You're welcome!

[@deetemple1]

Can I please access the free Date picker as shown in video? Thanks!

[@VBAA2Z]

Dee, all request processed. Please be sure to check the Spam folder too

[@ekilunewmai7033]

I love this datepickers because thank you so much

[@VBAA2Z]

Glad you like them!

[@yannip9554]

Greate job! Thanks for your work!

[@VBAA2Z]

Thanks for watching!

[@syamilman]

Just the thing that I have been looking for the past few days. Thanks a lot!

[@VBAA2Z]

You are welcome!

[@afpaocptcalma745]

Thank you so much! I have been looking a way to make date picker tool to work in my 64bit but i havent found one.. This is a big help sir!

[@VBAA2Z]

You are welcome!

[@jonathansakala8503]

Man this looks professional.... I am having problems in writing codes that can run on both 32 and 64 bit platforms. I hope tp learn something from you. You're Genius

[@VBAA2Z]

Hope it helps

[@usmanyahaya8011]

Awesome, I love your channel a lot. Hats off

[@VBAA2Z]

Thank you so much 😀

[@christianvanhalderen6757]

Looks really helpfull, Thank you!

[@VBAA2Z]

Glad it was helpful!

[@mistahdee]

Wow! awesome...gonna implement this on my project. Thanks! VBA A2Z!

[@VBAA2Z]

Great!

[@neilianedles9158]

This looks good! Looking forward on more users of this.

[@VBAA2Z]

you're most welcome!

[@robertlandkammer1684]

Amazing! Happy to found this channel 🙂

[@delbertwright6675]

Thank you for the video it helped a lot.

[@VBAA2Z]

You're welcome!

[@simonkyndt7889]

Great work! Thanks so much!!

[@VBAA2Z]

You're very welcome!

[@Wynand4]

Looks great. Thank you for sharing. Looking forward to being able to download the file and play with it in my user form. Great video as well

[@VBAA2Z]

Awesome, thank you!

[@sartorda]

GREAT. Thank you very much for that.

[@VBAA2Z]

You are welcome!

[@Chimpestry]

Very nice .... just what I was looking for.

[@VBAA2Z]

Glad I could help

[@gopinath9977]

Thank you, it's very useful

[@VBAA2Z]

Glad to hear that

[@siularellano3358]

Excellent datepicker, I thought that the complement for excel 2019 did not exist. Very good contribution.

[@VBAA2Z]

thanks

[@imerchan68]

Estaba buscando justamente esto para completar mi proyecto, muchas gracias por compartir... :)

[@gianowesenhagen8608]

great tutorials! Thanks!

[@VBAA2Z]

Glad you like them!

[@giox2806]

This is what I was looking for....! Super.

[@VBAA2Z]

Glad I could help!

[@pouryout4153]

Very instructive, thanks.

[@VBAA2Z]

You are welcome!

[@djchakal91]

Very nice calendar looks like a great alternative to the now defunct option embedded in excel

[@VBAA2Z]

Definitely!

[@yahyacarlos3885]

Thank you for your helpful project

[@VBAA2Z]

Glad it was helpful!

[@Ummler]

looks very nice, thanks!

[@VBAA2Z]

Thank you! Cheers!

[@poejoyer]

This help me a lot may i know what is the project id as i am confused with it since my excel cant install using Microsoft Date and Time Picker Control 6.0 (SP6) and no plugins allowed as well

[@VBAA2Z]

please download from here pamaitech.com/download

[@prestonmoulton3838]

This looks to me exactly what we are needing.

[@VBAA2Z]

Sure

[@JegErJoachim]

Super useful! Thank you!

[@VBAA2Z]

Glad it was helpful!

[@alisoroush9869]

This is perfect and very helpful! thank you

[@VBAA2Z]

Glad it was helpful!

[@vicsg8621]

hi the date picker is one of the most useful for me and I would like to ask whether I can use this in userform as well as on the worksheet in one excel file. Also, it would be great to know how to use the program to convert the dates for real values. Since I use these dates for determining calendar week and I am getting errors because the dates are not real values. P.S. I have tested both date picker in userform and in worksheet and having difficulties in merging both in one excel file. Thank you.

[@VBAA2Z]

Happy to assist if needed. the values from DatePicker are date. Are you able to share how you're trying to get week number?

[@vicsg8621]

How may I try to reach you ?

[@VBAA2Z]

@@vicsg8621 please find email in video desc

[@lexiconbuilders]

Hi there, the video specificly says is for a form, just though i share this info with you.

[@tyawong]

Thank you for sharing. I have been looking for solution for it !

[@VBAA2Z]

Glad it helped

[@manueloscarariasrodriguez8810]

It's wonderful that you share your knowledge. Thank you so much.

[@VBAA2Z]

You're most welcome, thanks for watching

[@luciferiq1428]

Thank you for the lesson, you, Sir, are so easy to follow makes this learning p;process fun....nicely done...

[@VBAA2Z]

You are very welcome

[@himanshuhalder956]

This looks like exactly what I needed for a project. Thanks! Great conte.nt

[@VBAA2Z]

Glad it was helpful!

[@Schick3r]

Very helpful. Thanks for your work!

[@VBAA2Z]

You're most welcome. Thanks for watching

[@Petrick-ri3sq]

Very helpful thank you

[@VBAA2Z]

Glad it was helpful!

[@aminasif9715]

Awesome work.

[@VBAA2Z]

Thank you so much 😀

[@marinokranjcec7210]

Exactly what I need for my project. Thx.

[@VBAA2Z]

Glad I could help!

[@Mkzeiry]

thanks!! very helpful

[@VBAA2Z]

Glad it helped!

[@manueloscarariasrodriguez8810]

It's wonderful that you share this kind of information. Thanks

[@VBAA2Z]

my pleasure, thanks for watching.

[@Excel-Shark]

This i genius!! what a champ!

[@VBAA2Z]

Thanks Michael.

[@VBAA2Z]

Please do not forget to subscribe to support the channel and for future updates.

[@YVNGUN0]

Amazing work!

[@VBAA2Z]

Thank you! Cheers!

[@meresandowiesda]

Extremely useful, thank you for sharing.

[@VBAA2Z]

You're very welcome!

[@malcolmt3125]

Has the free download link for this been removed.

[@user-ih4rc9rl6b]

Thank you very much for sharing your knowledge through this sample! It is very practical and I'm happy with it.

[@VBAA2Z]

Glad it was helpful!

[@hectorbolivar3777]

WOW I had a week working I made a data picker for my form but for some reason the tool offered by excel was not working for me, this could help me😁

[@VBAA2Z]

thanks. hope it helps

[@zechariaparas9885]

wow excellent video

[@VBAA2Z]

Many many thanks

[@HelmyMVP]

great work man

[@VBAA2Z]

Thank you! Cheers!

[@dovacmarlon7493]

Thanks for the video sir. Is amazing.

[@VBAA2Z]

Most welcome. thanks for watching

[@Livilee-od5vb]

Thanks for sharing your work

[@VBAA2Z]

Thanks for watching!

[@nareshchakowry7687]

Nice and helpful, thanks 😊

[@VBAA2Z]

Most welcome 😊

[@cristhianh1613]

Your videos are so great! I love your style. Thanks so much for your content!

[@VBAA2Z]

Thank you so much! thanks for watching.

[@GiselleBrat]

thank you for another useful video

[@VBAA2Z]

Glad it was helpful!

[@pedrocampos2529]

Awesome tutorial, congrats for the work

[@pedrocampos2529]

i intend to use it in a graduation project in witch i'm creating an KPI pannel, how may i quote your work in it?

[@VBAA2Z]

Thank you! Cheers!

[@7aidoori]

very useful tool, great job. thanks a lot for let us have this amazing code

[@VBAA2Z]

You are welcome!

[@simplejuan]

Thanks again for this wonderful project. Really nice datepicker

[@VBAA2Z]

You're welcome Glad you like it!

[@markjosephramos8018]

This is awesome!

[@VBAA2Z]

thanks!

[@rasgrego1]

Very informative

[@VBAA2Z]

Glad it was helpful!

[@mazenzagha8811]

Thanks you my dear your lessons are appreciated we hope you to show how we can search between two dates pls

[@VBAA2Z]

You're welcome and thanks for your suggestion.

[@francoismarsau6412]

Great and want to try this code. What is the number to download this demo code on the website?

[@VBAA2Z]

In the description.

[@AnkarajMarri007]

Thank you ....this is super.

[@VBAA2Z]

Welcome 😊

[@zobun]

I submitted download request from website, however there no download link available.

[@VBAA2Z]

please be sure to check spam folder too.

[@ActualGiles]

Top man. This is super-useful, and exactly what I needed for a project. Thanks!

[@VBAA2Z]

Great to hear! thanks for watching and feedback.

[@JahidFerdousbd]

this is so helpfull. thanks

[@VBAA2Z]

You're welcome!

[@stephenshockley6500]

I finally managed to make it work, however now I have a whole new problem. I’ve had to switch to a multipage form and now it will not populate the textbox with the date from the calendar.

[@shaimensgh]

How do I download your project man I really love it

[@VBAA2Z]

thanks. Please check video description

[@JérômeLANCE-c1c]

very interesting ! Thanks a lot

[@VBAA2Z]

You are welcome!

[@moustafaadel7157]

hi< thanks for ur time to help but i can't find the download page after filling the form < thanks in advance

[@VBAA2Z]

please download from here pamaitech.com/downloads/

[@guerreirodas6flores441]

How can I use this calendar in a cell instead of a userfom?

[@VBAA2Z]

check here. kzbin.info/www/bejne/iqTRg4qnjZaEatU

[@Ps_Sam]

Thanks soo much for this

[@VBAA2Z]

You're most welcome

[@srgroup4997]

Very helpful post!

[@VBAA2Z]

thanks!

[@a.s.mahshanhabib1987]

Its very useful. Thanks.

[@VBAA2Z]

You are welcome

[@Mylle123]

Looking forward to trying this 😊

[@VBAA2Z]

Hope you like it!

[@CarlosRivera-mp7mm]

Excelente trabajo muchas gracias ya recibi el archivo, saludos!

[@VBAA2Z]

Eres bienvenido. Gracias por ver

[@willmarbrin]

Hi! Where can i find the sample file?

[@VBAA2Z]

sure, please check video description for download link

[@user-fq6uu5uw4x]

can i have the copy on 028 ID i requested it a few days ago but no response.

[@VBAA2Z]

Please be sure to check spam folder too.

[@SynergyStep]

Thanks, good calendar!

[@VBAA2Z]

You're welcome!

[@lqc1014]

I write the email address, but no reply email for download this project.

[@VBAA2Z]

please be sure to check spam folder too. all request have been processed.

[@ionascurazvan3980]

Thank you for another great video! I've been following your series for a while now, and there's one problem I cannot fix with user forms. Can you adjust the user form to change it's size and zoom, depending on the user's screen resolution? This is a real issue when you create a userform in high resolution, and send it someone who has a low resolution, the controls would not fit the screen. Do you have any video on this topic by any chance?

[@VBAA2Z]

Try manipulating Zoom, Width and Height Poperties.

[@fritzadhinata9751]

good tutorial

[@VBAA2Z]

Thanks

[@EvJahvan]

Wow this is really awesome, I hope this project can be applicable to Microsoft Access Forms too. Would be really useful as stock date picker in access is really difficult to use and not very intuitive compared to this. Very excited to try it in Access projects. Thanks Sir.

[@VBAA2Z]

Thanks Jahvana, this was design especially for excel because of date picker issue in 64-bit but code should work with access form objects too.