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!

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

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

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

[@MuhammadShahAlam99]

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

[@VBAA2Z]

Thank you kindly!

[@Andesiteable]

Cool popup will be using in my user form!

[@VBAA2Z]

thanks!

[@ekilunewmai7033]

I love this datepickers because thank you so much

[@VBAA2Z]

Glad you like them!

[@hardyharry7223]

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

[@VBAA2Z]

Great!

[@imerchan68]

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

[@pedche5790]

excellent video and tool. thanks for sharing it freely.

[@VBAA2Z]

Glad it was helpful!

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

[@yannip9554]

Greate job! Thanks for your work!

[@VBAA2Z]

Thanks for watching!

[@robertlandkammer1684]

Amazing! Happy to found this channel 🙂

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

[@王大蠻-d1z]

Very helpful video. thanks for sharing.

[@VBAA2Z]

Glad it was helpful!

[@mistahdee]

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

[@VBAA2Z]

Great!

[@christianvanhalderen6757]

Looks really helpfull, Thank you!

[@VBAA2Z]

Glad it was helpful!

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

[@madhurimotamarri6571]

Amazing Tutorial - Just filled out the google form for it

[@VBAA2Z]

Thanks Madhuri.

[@djchakal91]

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

[@VBAA2Z]

Definitely!

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

[@cgd1037]

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

[@VBAA2Z]

thanks!

[@francoismarsau6412]

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

[@VBAA2Z]

In the description.

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

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

[@gianowesenhagen8608]

great tutorials! Thanks!

[@VBAA2Z]

Glad you like them!

[@delbertwright6675]

Thank you for the video it helped a lot.

[@VBAA2Z]

You're welcome!

[@Ummler]

looks very nice, thanks!

[@VBAA2Z]

Thank you! Cheers!

[@himanshuhalder956]

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

[@VBAA2Z]

Glad it was helpful!

[@neilianedles9158]

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

[@VBAA2Z]

you're most welcome!

[@manueloscarariasrodriguez8810]

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

[@VBAA2Z]

You're most welcome, thanks for watching

[@simonkyndt7889]

Great work! Thanks so much!!

[@VBAA2Z]

You're very welcome!

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

[@gopinath9977]

Thank you, it's very useful

[@VBAA2Z]

Glad to hear that

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

[@Chimpestry]

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

[@VBAA2Z]

Glad I could help

[@usmanyahaya8011]

Awesome, I love your channel a lot. Hats off

[@VBAA2Z]

Thank you so much 😀

[@pouryout4153]

Very instructive, thanks.

[@VBAA2Z]

You are welcome!

[@giox2806]

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

[@VBAA2Z]

Glad I could help!

[@JegErJoachim]

Super useful! Thank you!

[@VBAA2Z]

Glad it was helpful!

[@olamikusholabi3247]

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

[@VBAA2Z]

Glad it helped!

[@siularellano3358]

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

[@VBAA2Z]

thanks

[@Petrick-ri3sq]

Very helpful thank you

[@VBAA2Z]

Glad it was helpful!

[@aminasif9715]

Awesome work.

[@VBAA2Z]

Thank you so much 😀

[@Schick3r]

Very helpful. Thanks for your work!

[@VBAA2Z]

You're most welcome. Thanks for watching

[@yahyacarlos3885]

Thank you for your helpful project

[@VBAA2Z]

Glad it was helpful!

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

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

[@dukemanvillle]

Hi.. Love the datepicker x video .. I'm still waiting for the download. Should I be getting a download link ?

[@VBAA2Z]

Sent! please be sure to check spam folder as well.

[@dukemanvillle]

@@VBAA2Z Got it... Thank You !!

[@HelmyMVP]

great work man

[@VBAA2Z]

Thank you! Cheers!

[@markjosephramos8018]

This is awesome!

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

[@zechariaparas9885]

wow excellent video

[@VBAA2Z]

Many many thanks

[@Mkzeiry]

thanks!! very helpful

[@VBAA2Z]

Glad it helped!

[@ElMoy]

Great Video

[@VBAA2Z]

Thanks for the visit

[@PurgeboiUno]

Amazing work!

[@VBAA2Z]

Thank you! Cheers!

[@prestonmoulton3838]

This looks to me exactly what we are needing.

[@VBAA2Z]

Sure

[@alisoroush9869]

This is perfect and 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.

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

[@tyawong]

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

[@VBAA2Z]

Glad it helped

[@AnkarajMarri007]

Thank you ....this is super.

[@VBAA2Z]

Welcome 😊

[@marinokranjcec7210]

Exactly what I need for my project. Thx.

[@VBAA2Z]

Glad I could help!

[@rasgrego1]

Very informative

[@VBAA2Z]

Glad it was helpful!

[@manueloscarariasrodriguez8810]

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

[@VBAA2Z]

my pleasure, thanks for watching.

[@AdnanAhmad7]

Great video. Couldn't find anywhere for Office 365 64-Bit.

[@VBAA2Z]

thanks!

[@AdnanAhmad7]

@@VBAA2Z Can't scroll between years. The only way to go is month by month back to the intended year?

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

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

[@JahidFerdousbd]

this is so helpfull. thanks

[@VBAA2Z]

You're welcome!

[@Livilee-od5vb]

Thanks for sharing your work

[@VBAA2Z]

Thanks for watching!

[@besirozmen3733]

Thank you!

[@VBAA2Z]

You're welcome!

[@photogpphotogp7468]

Awesome datepicker! What is the Project ID for download?

[@VBAA2Z]

Please find in the description

[@MJLCabral]

@@VBAA2Z Hi, if I asked, it’s because the description here is not the same as you have on your blog, otherwise I hadn’t asked, also because the ID 028 project link goes to - VBA to read values in PDF Form without Reader or Acrobat API - VBA PDF Automation-12 - and not for - DatePickerX - DatePicker for Excel UserForm - Pop Up. Thanks This is the example i need. thanks again

[@photogpphotogp7468]

@@VBAA2Z Hi Pamai Where can I find this Demo file, which you show on the Video? There is no file in the download list with the name "UI UX 20 - Demo.xlsm". Can you send it by email to [e-mail], or indicate the Project ID to download it?

[@shaimensgh]

How do I download your project man I really love it

[@VBAA2Z]

thanks. Please check video description

[@abafirasse6824]

graet job

[@VBAA2Z]

thanks

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

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

[@Ps_Sam]

Thanks soo much for this

[@VBAA2Z]

You're most welcome

[@fritzadhinata9751]

good tutorial

[@VBAA2Z]

Thanks

[@GiselleBrat]

thank you for another useful video

[@VBAA2Z]

Glad it was helpful!

[@dovacmarlon7493]

Thanks for the video sir. Is amazing.

[@VBAA2Z]

Most welcome. thanks for watching

[@naveenkarthik3305]

This is exactly what i am looking for. how can i download this ?

[@VBAA2Z]

Please check video desc. for link

[@tanqiaoting6143]

Awesome!

[@VBAA2Z]

Thank you! Cheers!

[@alexanderschatz8494]

Wow. Your Channel is realy helpfull! I wan‘t to try this Pop up Date Picker. How can i download this Date Picker?

[@VBAA2Z]

Thanks a lot. Please check this link: vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html

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

[@dwsteyl]

Could you do a video on general guidelines to make 32-bit VBA compatible with 64-bit Excel, please?

[@VBAA2Z]

Hi Wessel, thanks for your suggestion. I have simple blog post on this vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html

[@zobun]

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

[@VBAA2Z]

please be sure to check spam folder too.

[@ElWiwif]

Thanks!

[@VBAA2Z]

Welcome!

[@nareshchakowry7687]

Nice and helpful, thanks 😊

[@VBAA2Z]

Most welcome 😊

[@djkujo007]

Nice!

[@VBAA2Z]

thanks