DatePicker for Excel UserForm 64-Bit Excel and 32-Bit Excel. Simply DragDrop and use

Поділитися
Вставка
  • Опубліковано 1 лют 2025

КОМЕНТАРІ • 682

  • @lchewang9114
    @lchewang9114 4 роки тому +10

    This is going to be life-saver for many VBA / Office Apps developers.
    Thanks for your contribution towards community.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You're very welcome!

  • @matosalmeidaflavio
    @matosalmeidaflavio 4 роки тому +5

    i'm brazilian and subscribed to the channel. And I want to publicly record my satisfaction with the teacher. There was a problem of language compatibility and he was extremely attentive in the solution. Congratulations and thank you very much

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You're very welcome.

  • @wennychez5606
    @wennychez5606 4 роки тому +4

    It is such a pain without datepicker in 64 bit Excel. This is definitely going to help us all. Thank you soo much Pamai

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You are most welcome

  • @Vrark
    @Vrark 2 роки тому +2

    Finally a solution Microsoft couldnt come up with. Thanks.

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      No problem 👍

  • @reacordovilla
    @reacordovilla 2 роки тому +1

    You're a life saver. watched so many videos but none suits my preference, till I came across your videos. thank you 🙂

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Happy to hear that!

  • @TheMarchack
    @TheMarchack 3 роки тому +1

    This is exactly what I was looking for. The most popular Microsoft DatePicker solution doesn't want to work on Windows 64 bit system and 64 bit Excel configuration.

  • @Evadisa-q8h
    @Evadisa-q8h Рік тому +1

    I'm blown away with the things you do with VBA and userfoms

  • @jonathansakala8503
    @jonathansakala8503 2 роки тому +1

    Thanx for this tutorial, i wish i got to your channel early enough...much love...Am enjoying every bit of what am seeing

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You are so welcome

  • @alainafriend5891
    @alainafriend5891 2 роки тому +2

    I adore this workaround. I've been looking for this for a long time. Thank you for offering it for free.

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You're so welcome!

    • @alainafriend5891
      @alainafriend5891 2 роки тому

      I tried downloading it from your site and still haven’t gotten the file. I filled out the form. Can you take a look or tell me what I’m doing wrong?

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      @@alainafriend5891 looks like the services were down for some time. please submit request again

    • @alainafriend5891
      @alainafriend5891 2 роки тому

      @@VBAA2Z I just filled out the request form again. Thanks!

    • @alainafriend5891
      @alainafriend5891 2 роки тому

      Still nothing?

  • @FirmanNoer
    @FirmanNoer 3 роки тому +1

    This is definitely going to help 64 bit users... thank you man...

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Happy to help!

  • @YMarshall77
    @YMarshall77 4 роки тому +1

    Thanks! I was looking for a date picker for user forms specifically. I'm so happy I found your video.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Glad to hear that.

  • @lchewang6512
    @lchewang6512 4 роки тому +2

    This is amazing Pamai, works great so far. I will review more and be in touch.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Please do!

  • @knowledgeispower5803
    @knowledgeispower5803 3 роки тому +1

    Wonderful dear. Was searching for a long time this type of Calendar. Thanks

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Thank you so much 🙂

  • @nathanbaker8979
    @nathanbaker8979 3 роки тому +1

    Perfect tool to upgrade my 32 bit file formatting utility.

  • @nikolaydimanov264
    @nikolaydimanov264 4 роки тому +1

    As there is no DatePicker for 64-bit MS Excel, I'm looking for other solutions. This looks very versatile and well-customized. I'm keen to try it.

  • @DetroiterDave
    @DetroiterDave 3 роки тому +1

    Excellent calendar for userforms. Works like it was built into Excel.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Glad it was helpful!

  • @michaelbattle9883
    @michaelbattle9883 Рік тому +2

    Fantastic, exactly what I was looking for.

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Great to hear!

  • @andynchuckles
    @andynchuckles 3 роки тому +1

    I can only strive to be as good as you at this stuff. Brilliant, thank you.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Thank you Andrew! we all learn from one another.

  • @marie-annec.3792
    @marie-annec.3792 2 роки тому +1

    Exactly what I was looking for ! Thank you ! Can't wait to try it !

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You are so welcome!

  • @sylvin3406
    @sylvin3406 Рік тому +1

    This is amazing! learned so much from your videos. Thank you!

    • @VBAA2Z
      @VBAA2Z  Рік тому

      You are so welcome!

  • @SwissMarkus
    @SwissMarkus 2 роки тому +1

    amazing Solution ! great Work 👍

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Thank you! Cheers!

  • @jamespadgett8083
    @jamespadgett8083 2 роки тому +1

    I love the video and am eager to try this on a worksheet I am working on.
    Thank You for your efforts.

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You are welcome!

  • @MrDKLloyd
    @MrDKLloyd 2 роки тому +1

    This is a great Video, Exactly what i was looking for as i needed to use the Old ActiveX Control which is not available anymore

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Glad it helped!

  • @subratadatta3914
    @subratadatta3914 4 роки тому +1

    Thank u. Wish your channel prosper day by day.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      So nice of you. thanks

  • @kninetube4108
    @kninetube4108 Рік тому +1

    I really needed this. I was stuck, thanks!

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Glad to hear it!

  • @kingsoko5319
    @kingsoko5319 2 роки тому +1

    This is needed more than ever, thank you

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      :) most welcome!

  • @scottansir7708
    @scottansir7708 4 роки тому +1

    awesome work. appreciate your commitment to this community.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      I appreciate that!

  • @hamadafayyad6298
    @hamadafayyad6298 3 роки тому +1

    Great Work, your channal saves my life..thank you

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Glad to hear that!

  • @mrinalkgp2009
    @mrinalkgp2009 9 місяців тому +1

    This is very helpful for beginners vba learners.

    • @VBAA2Z
      @VBAA2Z  9 місяців тому

      Glad it was helpful!

  • @hizinbygr2357
    @hizinbygr2357 Рік тому +1

    I just love your work Sir. Thanks so much.

    • @VBAA2Z
      @VBAA2Z  Рік тому

      you're most welcome!

  • @naiyanaboonma5434
    @naiyanaboonma5434 3 роки тому +1

    This is amazing. Very useful video. Thanks for sharing it for free.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      You're very welcome!

  • @natcongreso2763
    @natcongreso2763 Рік тому +1

    This is very helpful thank you for sharing your expertise.

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Thanks for watching!

  • @jatinjhingan
    @jatinjhingan 5 місяців тому +1

    Thanks for your contribution towards community.

    • @VBAA2Z
      @VBAA2Z  5 місяців тому

      It's my pleasure

  • @eladalcalay9926
    @eladalcalay9926 4 роки тому +1

    You're soo great! you inspired me with your amazing tools for vba developer's thankss!

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Glad you like them! Thanks Elad.

  • @siphelelemakhathini1787
    @siphelelemakhathini1787 2 роки тому +1

    Wow, amazing. I've been using shape calendar, this is really smart.

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Glad it was helpful!

  • @cealizarserrano7015
    @cealizarserrano7015 Рік тому +1

    Amazing work! makes my life a lot easier. Thank you

    • @VBAA2Z
      @VBAA2Z  Рік тому

      No problem!

    • @cealizarserrano7015
      @cealizarserrano7015 Рік тому

      @@VBAA2Z hi, i tried downloading the datepicker, filled out the questionnaire but I have not received it yet. How exactly do I download it? Do i get it via email?

    • @VBAA2Z
      @VBAA2Z  Рік тому

      please recheck your spam folder.

    • @cealizarserrano7015
      @cealizarserrano7015 Рік тому +1

      @@VBAA2Z i found it! Thank u!

  • @davidlinton4127
    @davidlinton4127 2 роки тому +1

    GREAT STUFF! Drinking from the fire hose again, thank you.

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Glad to help!

  • @caycehouseofcats2740
    @caycehouseofcats2740 4 роки тому +1

    Thank you for making this available for my Logbook project.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You're very welcome!

  • @petrvyskocil6065
    @petrvyskocil6065 2 роки тому +1

    This looks amazing! Hoping to test it soon...

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Hope you enjoy it!

  • @cyplexgaming5168
    @cyplexgaming5168 2 роки тому

    Looking forward to working with this awesome Tool. Thank you for your work!

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      you're welcome!

  • @paradoix
    @paradoix 2 роки тому +1

    Thanks for the sharing the 64-bit excel solution

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You're welcome!

  • @deep_fake5547
    @deep_fake5547 2 роки тому +1

    Exactly what I was looking for ! Thank you !

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You are welcome!

  • @FINALLYINGOLD
    @FINALLYINGOLD 2 роки тому +1

    Thanks been looking this for a while now...thanks for the help

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Glad I could help

  • @jamesh-kc7rk
    @jamesh-kc7rk Рік тому +1

    Another masterpiece. Thank you so much for sharing.

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Thank you! Cheers!

  • @exceladvisor29
    @exceladvisor29 4 роки тому +1

    Dear You really solved my biggest problem thanks alot stay blessed

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You are most welcome. Stay blessed.

  • @scotolivera8207
    @scotolivera8207 4 роки тому +2

    Sir thank you sooooo much. God bless you, i hope you start adding episode for the VSTO series, that will be excellent if you can

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You're welcome and God bless you too. More to come on VSTO.

    • @scotolivera8207
      @scotolivera8207 4 роки тому +1

      VBA A2Z cannot wait sir

  • @RussianGhost
    @RussianGhost 2 роки тому +1

    awesome datepicker, you're a life saver

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Thanks for watching!

  • @pierreconde9389
    @pierreconde9389 3 роки тому +1

    Sounds like exactly what I need, gonna try it asap !

  • @matthiaskaufmann7443
    @matthiaskaufmann7443 2 роки тому +1

    Great content! Thanks for this video and the tool!

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Glad you enjoyed it!

  • @hcr1281
    @hcr1281 2 роки тому +1

    Great job indeed!! I am loving it!

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Thank you! Cheers!

  • @farukzeynep1
    @farukzeynep1 2 роки тому

    Just the datepicker I was looking for

  • @patdelaney299
    @patdelaney299 3 роки тому +1

    I have been looking for yhis for so long. Thanks so much

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      You're welcome. thanks for watching

  • @ekilunewmai7033
    @ekilunewmai7033 2 роки тому +1

    Perfect fit for my project. Thank you so much

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You’re welcome 😊

  • @Brad-fh2vn
    @Brad-fh2vn Рік тому +1

    Your works are amazing Sir thank you

    • @VBAA2Z
      @VBAA2Z  Рік тому

      You are most welcome

  • @NancyCa198-a
    @NancyCa198-a 4 роки тому +1

    Really appreciate sharing this useful tool. Many thanks!

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You're very welcome!

  • @lukethomson1544
    @lukethomson1544 4 роки тому +1

    Thanks for all the great work!

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Thanks for watching!

  • @oscarcuellar3891
    @oscarcuellar3891 3 роки тому +1

    Awesome date picker, very well designed! any chance you can tell me how to print an user form in landscape mode? I made one for one project but the format is in landscape and when I print it It does not look good.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Check print settings from Excel app not userform

    • @oscarcuellar3891
      @oscarcuellar3891 3 роки тому

      @@VBAA2Z I am working on a project and your UI userform series convinced me to switch from another method I had to yours :) I tried to use the datepickerX (workbook) you sent me but I ran into some issues so I was wondering if you can send me the userform version. Thank you for all your help!

  • @xavierparadell2427
    @xavierparadell2427 3 роки тому +1

    Thanks for sharing your knowledge. What great work !!!

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      My pleasure!

    • @xavierparadell2427
      @xavierparadell2427 3 роки тому

      @@VBAA2Z I'm sorry to trouble you. By the time I posted my comment I also asked for the VBA code (twice), but I've not received it yet. I have read that sending is an automatic process. I submitted two different e-mail addresses. There's no e-mail in my spam folder.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      @@xavierparadell2427 not sure why that is because it is automatically sent.
      please email me (id in video desc.) I'll manually process it

  • @hilelsolis2234
    @hilelsolis2234 2 роки тому +1

    This looks great!.. waiting for receive it and try it

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Hope you enjoy it!

  • @christopherworsley6653
    @christopherworsley6653 2 роки тому +1

    Just what I'm looking for, thank you

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You're welcome!

  • @RunGord
    @RunGord 3 роки тому +1

    This is going to be very helpful, thanks!

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Glad to hear it!

  • @GIG-ATT-ATT-GIG
    @GIG-ATT-ATT-GIG 4 роки тому +2

    This is amazing. Thanks for sharing it for free.

  • @sabargjg2479
    @sabargjg2479 2 роки тому +1

    great Channels.... thanks for sharing

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Thanks for watching

  • @GIG-ATT-ATT-GIG
    @GIG-ATT-ATT-GIG 4 роки тому +2

    Hello Pamai, I have tried it and it’s workings great. One request, it would be great if you can update it so we can use it in Excel Sheets/cells too. Thanks

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Sure thanks for your suggestion.

    • @miiihaaas
      @miiihaaas 4 роки тому

      And if it can select cells in background of user form, and to stay open after picking up the date so we can select next cell to input next date...

  • @funniq
    @funniq 4 роки тому +1

    Thanks for sharing all this knowledge with your high quality videos

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You're welcome. Glad you like them!

  • @kerimcelebi5534
    @kerimcelebi5534 2 роки тому +1

    verdiğiniz faydalı bilgiler için ve emeğiniz için çok teşekkürler

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Teşekkürler!

  • @sandymanrulz
    @sandymanrulz 3 роки тому

    Really appreciate the effort 👍👍👍

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Thanks a lot 😊

  • @projectsharing8085
    @projectsharing8085 2 роки тому +1

    Looks like what exactly I need. Thanks!

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Glad I could help!

  • @soufianemokhliss
    @soufianemokhliss 2 роки тому +1

    Amazing work, hats off

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Thank you! Cheers!

  • @GoncaloFly
    @GoncaloFly 4 роки тому +2

    This is going to ease my work a lot. thank you.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Great to hear! You are welcome!

  • @KuroDhd
    @KuroDhd Рік тому +1

    perfect for my vba project

  • @johndsouza1617
    @johndsouza1617 3 роки тому +1

    Really struggled to find solution, and getting sense, my old file continue to remain useful

  • @larissakaur59
    @larissakaur59 11 місяців тому

    Looks good. To confirm, do I need to request to download Products 108, 109, and 110? FYI, the request form asks for a Project ID, not a Product ID. I am assuming that it is asking for the number that appears next to the product on the downloads page.

    • @VBAA2Z
      @VBAA2Z  11 місяців тому

      that is correct. Are you facing issue?

  • @GiselleBrat
    @GiselleBrat Рік тому +1

    Worth watching your video. thank you

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Glad it was helpful!

  • @AlengChawang
    @AlengChawang Рік тому

    Exactly what I’m looking for thank you so much

  • @saumitaroy4967
    @saumitaroy4967 2 роки тому +1

    This is a great & amazing work. Thanks a lot!

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Thank you too!

  • @chongochachi9477
    @chongochachi9477 Рік тому +1

    Great 👍 work

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Thank you so much 😀

  • @melivo853
    @melivo853 4 роки тому +1

    This is awesome Pamai. Thank you soo much

  • @jasonemans9062
    @jasonemans9062 2 роки тому +1

    yay date picker.. now i also need a time picker. 😄

  • @prashanthramesh6408
    @prashanthramesh6408 3 роки тому +1

    This is amazing work. Thanks a lot! Quick question, I have a requirement to include calendar week to the date picker. Have you done anything similar? Appreciate your response.

    • @VBAA2Z
      @VBAA2Z  3 роки тому +1

      Thanks, Prashanth.
      It does not include calendar week at the moment however it should be easy replication

  • @francinepowell9296
    @francinepowell9296 3 роки тому

    Looks Good! Want to try it out to hopefully solve a DateTimePicker control that is not working with Windows 10 and Excel 365!

  • @asadullahislam1917
    @asadullahislam1917 3 роки тому +1

    Excellent👍

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Thank you! Cheers!

    • @asadullahislam1917
      @asadullahislam1917 3 роки тому

      The date only show textbox. How to show any cell number?

  • @Rahul-sn1wn
    @Rahul-sn1wn 4 роки тому

    This is brilliant Pamai. Thanks!

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You're so welcome!

  • @DrPPrabu
    @DrPPrabu 4 роки тому +1

    Thank u sir for your contribution...We are waiting for more on VSTO sir....

    • @VBAA2Z
      @VBAA2Z  4 роки тому +1

      Will upload soon

    • @DrPPrabu
      @DrPPrabu 4 роки тому

      @@VBAA2Z Thank you Sir

  • @brokenMikrophone
    @brokenMikrophone 3 роки тому

    this is some good looking date picker. don't mind if I do use this one real quick.
    But for future projects i want to write my own. very inspiring

  • @Jusils
    @Jusils Рік тому

    Great solution 👍

  • @weeeeeboooo2759
    @weeeeeboooo2759 2 роки тому +1

    Very useful and looks great

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Glad you think so!

  • @rodmaxwell8182
    @rodmaxwell8182 3 роки тому

    Really good video - this will help me quite a bit.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Glad it helped

  • @malcolmt3125
    @malcolmt3125 4 роки тому +2

    Still playing with this, I did not say before, that I have been looking for a Date Picker that works with Office (64) for months and months, well worth donations.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      thanks for your support!

  • @TheZombiefieR
    @TheZombiefieR 3 роки тому +1

    Very helpful, thanks! :)

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Glad it was helpful!

  • @geosake2831
    @geosake2831 3 роки тому +1

    seems nice, waiting to try it

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Hope you like it!

  • @sureshpallifeandbusinessco6049
    @sureshpallifeandbusinessco6049 2 роки тому +1

    Very nice project

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Thank you! Cheers!

  • @acmepune
    @acmepune 4 роки тому +1

    Dear sir,
    I am a physician from India. Your DatePicker was extremely useful in my research database project. Thanks for sharing. Stay blessed, sir! How to donate besides paypal?

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Hi Suresh, glad you found them useful. Please reach to me at vbaa2z.team@gmail.com / Facebook messenger I can share additional options. thanks.

  • @enriquedeamesti3212
    @enriquedeamesti3212 3 роки тому +1

    Thanks for your video, very clear and helpful information
    I might be doing something wrong bc when I filled the google form yesterday (project 028) nothing has shown up in my email so far, nor in spam. Can you help me?

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      please be sure to check spam folder too. If not you may want to re-submit and ensure email id is correct

  • @ravindrapatel4591
    @ravindrapatel4591 3 роки тому +1

    Excellent work done.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Thank you! Cheers!

  • @MBBajesh
    @MBBajesh 3 роки тому +1

    This is definitely very helpful. Thanks

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Glad you think so! thanks for watching.

  • @FreemanReuben
    @FreemanReuben 4 роки тому +1

    Excellent work 👍

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Thank you! Cheers!

  • @nap_boule
    @nap_boule 4 роки тому +1

    This awesome, thank you. Lately I've been trying to learn Tableau. And i want to know how I can incorporate Tableau into VBA for easier use with excel userforms and such. Or is that not a possibility? Haven't found much on the subject so i wanted to pick your brain. again, for the great work

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      I'll research bit on this topics and come back to you.
      Google for fastest answer.

  • @naimurrana5708
    @naimurrana5708 2 роки тому +1

    awesome lecture

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Thanks a lot!

  • @azel2239
    @azel2239 4 роки тому +1

    Thanks for this beautiful datepicker. Is this available for worksheets too?

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Yes, it is. You must have missed it.
      ua-cam.com/video/TsnRWqX1Q4s/v-deo.html