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

[@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.

[@ayoubbakkari7709]

this is my best VBA youtube chanel

[@VBAA2Z]

Thanks!

[@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

[@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.

[@lilynewmai8314]

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

[@VBAA2Z]

My pleasure!

[@mahensolanki8972]

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

[@VBAA2Z]

Glad to help

[@ronedwardyap6940]

Do you download it?

[@hardyharry7223]

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

[@VBAA2Z]

Great!

[@MuhammadShahAlam99]

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

[@VBAA2Z]

Thank you kindly!

[@mvining7]

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

[@VBAA2Z]

You're very welcome!

[@syamilman]

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

[@VBAA2Z]

You are welcome!

[@ravindrapatel4591]

Excellent work done for new to Excel VBA.

[@VBAA2Z]

Glad you think so! thanks for watching.

[@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

[@jovannijabat2004]

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

[@VBAA2Z]

Awesome, thank you!

[@usmanyahaya8011]

Awesome, I love your channel a lot. Hats off

[@VBAA2Z]

Thank you so much 😀

[@pedche5790]

excellent video and tool. thanks for sharing it freely.

[@VBAA2Z]

Glad it was helpful!

[@mistahdee]

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

[@VBAA2Z]

Great!

[@robertlandkammer1684]

Amazing! Happy to found this channel 🙂

[@王大蠻-d1z]

Very helpful video. thanks for sharing.

[@VBAA2Z]

Glad it was helpful!

[@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!

[@yannip9554]

Greate job! Thanks for your work!

[@VBAA2Z]

Thanks for watching!

[@neilianedles9158]

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

[@VBAA2Z]

you're most welcome!

[@madhurimotamarri6571]

Amazing Tutorial - Just filled out the google form for it

[@VBAA2Z]

Thanks Madhuri.

[@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

[@simonkyndt7889]

Great work! Thanks so much!!

[@VBAA2Z]

You're very welcome!

[@olamikusholabi3247]

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

[@VBAA2Z]

Glad it helped!

[@PeterChambers-gb4bk]

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

[@VBAA2Z]

good to hear

[@christianvanhalderen6757]

Looks really helpfull, Thank you!

[@VBAA2Z]

Glad it was helpful!

[@aminasif9715]

Awesome work.

[@VBAA2Z]

Thank you so much 😀

[@gianowesenhagen8608]

great tutorials! Thanks!

[@VBAA2Z]

Glad you like them!

[@siularellano3358]

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

[@VBAA2Z]

thanks

[@Ummler]

looks very nice, thanks!

[@VBAA2Z]

Thank you! Cheers!

[@Andesiteable]

Cool popup will be using in my user form!

[@VBAA2Z]

thanks!

[@giox2806]

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

[@VBAA2Z]

Glad I could help!

[@pouryout4153]

Very instructive, thanks.

[@VBAA2Z]

You are welcome!

[@markjosephramos8018]

This is awesome!

[@VBAA2Z]

thanks!

[@Chimpestry]

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

[@VBAA2Z]

Glad I could help

[@Petrick-ri3sq]

Very helpful thank you

[@VBAA2Z]

Glad it was helpful!

[@cristhianh1613]

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

[@VBAA2Z]

Thank you so much! thanks for watching.

[@ekilunewmai7033]

I love this datepickers because thank you so much

[@VBAA2Z]

Glad you like them!

[@zechariaparas9885]

wow excellent video

[@VBAA2Z]

Many many thanks

[@gopinath9977]

Thank you, it's very useful

[@VBAA2Z]

Glad to hear that

[@JegErJoachim]

Super useful! Thank you!

[@VBAA2Z]

Glad it was helpful!

[@Mkzeiry]

thanks!! very helpful

[@VBAA2Z]

Glad it helped!

[@delbertwright6675]

Thank you for the video it helped a lot.

[@VBAA2Z]

You're welcome!

[@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.

[@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

[@manueloscarariasrodriguez8810]

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

[@VBAA2Z]

You're most welcome, thanks for watching

[@sartorda]

GREAT. Thank you very much for that.

[@VBAA2Z]

You are welcome!

[@yahyacarlos3885]

Thank you for your helpful project

[@VBAA2Z]

Glad it was helpful!

[@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.

[@himanshuhalder956]

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

[@VBAA2Z]

Glad it was helpful!

[@rasgrego1]

Very informative

[@VBAA2Z]

Glad it was helpful!

[@cgd1037]

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

[@VBAA2Z]

thanks!

[@djchakal91]

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

[@VBAA2Z]

Definitely!

[@Schick3r]

Very helpful. Thanks for your work!

[@VBAA2Z]

You're most welcome. Thanks for watching

[@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.

[@YVNGUN0]

Amazing work!

[@VBAA2Z]

Thank you! Cheers!

[@Livilee-od5vb]

Thanks for sharing your work

[@VBAA2Z]

Thanks for watching!

[@alisoroush9869]

This is perfect and very helpful! thank you

[@VBAA2Z]

Glad it was helpful!

[@HelmyMVP]

great work man

[@VBAA2Z]

Thank you! Cheers!

[@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.

[@prestonmoulton3838]

This looks to me exactly what we are needing.

[@VBAA2Z]

Sure

[@JahidFerdousbd]

this is so helpfull. thanks

[@VBAA2Z]

You're welcome!

[@besirozmen3733]

Thank you!

[@VBAA2Z]

You're welcome!

[@manueloscarariasrodriguez8810]

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

[@VBAA2Z]

my pleasure, thanks for watching.

[@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!

[@fritzadhinata9751]

good tutorial

[@VBAA2Z]

Thanks

[@nareshchakowry7687]

Nice and helpful, thanks 😊

[@VBAA2Z]

Most welcome 😊

[@Ps_Sam]

Thanks soo much for this

[@VBAA2Z]

You're most welcome

[@srgroup4997]

Very helpful post!

[@VBAA2Z]

thanks!

[@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!

[@GiselleBrat]

thank you for another useful video

[@VBAA2Z]

Glad it was helpful!

[@simplejuan]

Thanks again for this wonderful project. Really nice datepicker

[@VBAA2Z]

You're welcome Glad you like it!

[@francoismarsau6412]

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

[@VBAA2Z]

In the description.

[@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!

[@AnkarajMarri007]

Thank you ....this is super.

[@VBAA2Z]

Welcome 😊

[@imerchan68]

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

[@tyawong]

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

[@VBAA2Z]

Glad it helped

[@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.

[@meresandowiesda]

Extremely useful, thank you for sharing.

[@VBAA2Z]

You're very welcome!

[@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

[@mornegericke2462]

great vid!

[@VBAA2Z]

thanks!

[@JérômeLANCE-c1c]

very interesting ! Thanks a lot

[@VBAA2Z]

You are welcome!

[@dovacmarlon7493]

Thanks for the video sir. Is amazing.

[@VBAA2Z]

Most welcome. thanks for watching

[@marinokranjcec7210]

Exactly what I need for my project. Thx.

[@VBAA2Z]

Glad I could help!

[@7aidoori]

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

[@VBAA2Z]

You are welcome!

[@SynergyStep]

Thanks, good calendar!

[@VBAA2Z]

You're welcome!

[@mariosantos871]

Thank you.

[@VBAA2Z]

You're welcome!

[@a.s.mahshanhabib1987]

Its very useful. Thanks.

[@VBAA2Z]

You are welcome

[@geraldmenong3033]

thanks for sharing 😍

[@VBAA2Z]

No problem 👍

[@danilomoraess1707]

thx from brasil

[@VBAA2Z]

Most welcome. thanks for watching.

[@aerockaerospace1058]

Good Job

[@VBAA2Z]

thanks

[@andrews7736]

Thanks for this!

[@VBAA2Z]

No worries!

[@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.

[@shaimensgh]

How do I download your project man I really love it

[@VBAA2Z]

thanks. Please check video description

[@maulanamuslim2504]

thank you sir

[@VBAA2Z]

Most 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/

[@jamesianpenaranda9535]

awesome tutorial! I was wondering how we can get the file for it. already answered the google form for it.. thanks teacher!

[@VBAA2Z]

Glad it was helpful! thanks for watching. please be sure to check spam folder too

[@mahjoubbessem786]

Thank you

[@VBAA2Z]

You're welcome