Modern ui DatePicker with Excel VBA

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ธ.ค. 2024

ความคิดเห็น • 59

  • @mtotowamungu8259
    @mtotowamungu8259 2 ปีที่แล้ว

    Thanks for the great idea, 2 weeks ago I made myself a similar datepicker. But putting a circle behind the numbers looks even better.
    Thanks for sharing.

  • @ahmetatasay9217
    @ahmetatasay9217 2 ปีที่แล้ว +2

    Çok Teşekkürler, Projelerimize kalite katacak bir çalışma....

    • @ahmetatasay9217
      @ahmetatasay9217 2 ปีที่แล้ว +1

      Mehmet Ali Bey, DatePicker Çalışmanızı bir projemde kullanmak istedim fakat bir hata ile karşılaştım. Acaba Bu Durumu Nasıl Çözebiliriz.
      Hata İle Alakalı ilgili video Linki
      drive.google.com/drive/folders/1kUVtUHrrscCogDaATIG5hf5jjP1DK_ot?usp=share_link

  • @itamaroliveirasampaio4628
    @itamaroliveirasampaio4628 2 ปีที่แล้ว +1

    Obrigado por compartilhar... Parabéns pelo trabalho! ficou simplesmente sensacional.

  • @josenildosabino574
    @josenildosabino574 2 ปีที่แล้ว +3

    Simplesmente e maravilhoso parabéns pelo trabalho obrigado por compartilhar seu conhecimento com todos nós.

  • @OrganicSheets
    @OrganicSheets 2 ปีที่แล้ว +2

    Ótimo trabalho, inspiração para todos nós.

  • @itamaroliveirasampaio4628
    @itamaroliveirasampaio4628 2 ปีที่แล้ว

    Você vai disponibilizar o Arquivo?

  • @grsnoliveira77
    @grsnoliveira77 2 ปีที่แล้ว

    Oh! Always surprised! One video better than the other! Congratulations on the work!👏💯👐👍😎

  • @tazman6207
    @tazman6207 2 ปีที่แล้ว +2

    This is a very attractive date picker, however it only starts at 2019 and you can't go back earlier than that. Plus only loops within a year so in Jan 2022 if you click back instead of Dec 21 it goes to Dec 22. Finally in office 365 when you float over the dates the numbers disappear. They are still there because you can see them when you go over them with the mouse but when you are not over them they have a white background and you can't see the number.

    • @tazman6207
      @tazman6207 2 ปีที่แล้ว +1

      Not all the number disappear. It appears to be the last week in the month and then only some days.

    • @grsnoliveira77
      @grsnoliveira77 2 ปีที่แล้ว +1

      @@tazman6207
      Hi! Sorry! But I also downloaded it and it is working perfectly. Shows dates correctly, if the months go back, the year will also change. As for the year that starts in 2019, in the video you can see that in the location of the year, it is possible to change the year by typing the respective year that you want to view, very simple!😊😉😉

    • @tazman6207
      @tazman6207 2 ปีที่แล้ว

      Gerson Olivia are you using 365, yes you can type a year in but that defeats the purpose of a date picker. Historical years are more likely to be needed than future years. Plus the numbers disappear. It looks great and I was just providing user feedback.

    • @grsnoliveira77
      @grsnoliveira77 2 ปีที่แล้ว

      @@tazman6207 👍👍🙏Me too, sorry!

    • @techafiz5691
      @techafiz5691 2 ปีที่แล้ว

      @@tazman6207
      Hi! With the update, your request has been resolved! He always surprises! Great!

  • @leegarrett1908
    @leegarrett1908 ปีที่แล้ว

    Omg you sir are awesome vba king! THANKYOU for sharing and even making the files available for download. Keep up the amazing work. I hope you can answer my question on another video I commented on of yours(re combobox)

  • @7aidoori
    @7aidoori 2 ปีที่แล้ว +2

    The design and implementation are more than wonderful and I appreciate the effort you put into this wonderful code. I checked the code and didn't find any error and yet I keep getting an error message
    Error 13
    type mismatch
    Is it possible to reach a solution?
    Thank you so much

    • @maligokmen
      @maligokmen  2 ปีที่แล้ว

      if you send me the your sample file i can help you

    • @grsnoliveira77
      @grsnoliveira77 2 ปีที่แล้ว

      @@maligokmen
      Eminim bana sunulan hatanın aynısıdır! Ve gg.aa.yyyy tarihini gg/aa/yyyy olarak biçimlendirmem için bana rehberlik ettiniz.

  • @MuhammadShahAlam99
    @MuhammadShahAlam99 2 ปีที่แล้ว +1

    Hi , Excellent Work !!! Can you share the file ? Also , Tutorial video how create it would be wonderful . Thank You

  • @FranciscoJose-fh6fn
    @FranciscoJose-fh6fn 2 ปีที่แล้ว +1

    wonderful, your work and show, congratulations. will teach you how to make or make the file available to us....

  • @jesusjohanncarrascoaguilar8449
    @jesusjohanncarrascoaguilar8449 11 หลายเดือนก่อน

    Eso es con un API ?

  • @moisesperaza3830
    @moisesperaza3830 2 ปีที่แล้ว

    Que creatividad mi hermano, se agradece

  • @takeflavio
    @takeflavio 2 ปีที่แล้ว +1

    I can't download this file...help me brother

  • @blackhatcsgo
    @blackhatcsgo ปีที่แล้ว

    hocam yıl seçimi yaparken d ve a yazısı geliyor onu nasıl kaldırabiliriz ? birde iki text box tarih arası veriyi takvimde sarı olarak gösterebilirmiyiz. Örneğin texboxumuzda tarih var ve biz diyelim datepicker i çalıştırdık o tarihi direk açıyor ekrana getiriyor ya işte oraya bir koşul ekleyebilirmiyiz eğer işte text box 2 boş değilse textbox2 deki tarih aralığına kadar sarılayabilirmiyiz takvimi ?

    • @maligokmen
      @maligokmen  ปีที่แล้ว

      @ercanakpinar836 İkon fontu eksik olduğu için a ve d şeklinde görünüyor, onlar yukarı ve aşağı butonları dosyayı güncelledim,font klasörü içindeki myicons fontunu yükleyin

    • @maligokmen
      @maligokmen  ปีที่แล้ว

      diğer soru için de bir çalışma yapayım olursa size bildiririm

    • @blackhatcsgo
      @blackhatcsgo ปีที่แล้ว

      @@maligokmen hocam eğer vaktiniz olursa projem üzerinde bana yardımcı olabilirmisiniz. Ve sizin şıklığınızı çok beğeniyorum projemin girişine sizin login ininizi entegre ettim fakat dediğim gibi projem eski nesil duruyor görsel anlamda biraz birşeyler katabilirmisiniz ? varsa mail adresinizi alabiliriyim. Bende elimden geldiğince bişeyler yazıyorum visual basic çok bildiğim söylenemez ama vba da gayet istediğimi yaptırabiliyorum bugüne kadar.

    • @maligokmen
      @maligokmen  ปีที่แล้ว

      Beyzade83@hotmail.com veya WhatsApp'tan ulaşabilirsiniz

    • @llokmanhoxhaxhiku8287
      @llokmanhoxhaxhiku8287 ปีที่แล้ว

      Hocam indirme linki göremiyorum

  • @alexandermoncada5920
    @alexandermoncada5920 2 ปีที่แล้ว +1

    Espectacular 😃

  • @jalpank
    @jalpank 2 ปีที่แล้ว +2

    Great sir 👌 please make this in English language please

    • @maligokmen
      @maligokmen  2 ปีที่แล้ว +1

      @Kantibhai Bakraniya you can download English version

    • @grsnoliveira77
      @grsnoliveira77 2 ปีที่แล้ว +1

      @@maligokmen
      Congratulations! Always willing to help! In addition to making the English version, he updated the formation to select the year, as someone had commented. Your willingness to help is admirable! This is rare!An example to follow!👏👐🙏

  • @abyshekkumar
    @abyshekkumar 2 ปีที่แล้ว

    This is so beautiful. Thanks for this. It would be great if you could make the source code available. Thanks again.

  • @djkujo007
    @djkujo007 6 หลายเดือนก่อน

    This is really nice

  • @kadirergul5812
    @kadirergul5812 2 ปีที่แล้ว +1

    Emeğinize sağlık iyi bir çalışma olmuş

  • @romilgupta8922
    @romilgupta8922 ปีที่แล้ว

    superb..!!!

  • @ristantosky
    @ristantosky ปีที่แล้ว

    this is cool. Is there any download link sir?

    • @maligokmen
      @maligokmen  ปีที่แล้ว

      Send me your mail address

  • @itamaroliveirasampaio4628
    @itamaroliveirasampaio4628 2 ปีที่แล้ว

    Excelente!...Parabéns!

  • @fksoftware
    @fksoftware 2 ปีที่แล้ว

    Thanks for sharing Sir.
    I tried to run it but I got "Run-time error '13':
    Type mismatch.
    Please help resolve this issue.

    • @maligokmen
      @maligokmen  2 ปีที่แล้ว +1

      What version of Windows you are using

    • @fksoftware
      @fksoftware 2 ปีที่แล้ว

      @@maligokmen Windows 11 Sir.

    • @maligokmen
      @maligokmen  2 ปีที่แล้ว +1

      ​@@fksoftwareCan you download the file and try again?

    • @leegarrett1908
      @leegarrett1908 ปีที่แล้ว

      I just tried this on windows 10 excel 2016 and got the same error but i can open the datepicker form by itself. Do I need to add a reference or something to call it on the userform

    • @maligokmen
      @maligokmen  ปีที่แล้ว

      What is the time of your computer date format

  • @fksoftware
    @fksoftware 2 ปีที่แล้ว +1

    Very impressive. Please make the file available.

  • @oguzturkyilmaz543
    @oguzturkyilmaz543 2 ปีที่แล้ว

    Ya hocam var ya allah tuttuğunu altın etsin. Bu microsoftçuların yatacak yeri yok arkadaş. 32 bitte çalışan bir çok nesne 64 bitte çalışmıyor. Bu da onlardan biriydi. Listview componentinide 64 bitte bir çalıştırabilsek tadından yenmeyecek. Çok çok teşekkürler.

    • @maligokmen
      @maligokmen  2 ปีที่แล้ว

      Biz de kendi listviewimizi yaptık ne yapalım😀

  • @kaboregabriel5840
    @kaboregabriel5840 ปีที่แล้ว

    Beautiful🎉🎉🎉
    File please

  • @abdelhalimoh4616
    @abdelhalimoh4616 2 ปีที่แล้ว

    keep up tks for this vidéo.

  • @user-ls4nn4jn9q
    @user-ls4nn4jn9q ปีที่แล้ว

    Man we want to download files and try it. We haven't any experience in apis and this things to make it from zero.
    Happy Random 🌙

    • @maligokmen
      @maligokmen  ปีที่แล้ว

      Can you reach me from whatssapp

  • @HerculesSantosLoyola
    @HerculesSantosLoyola 2 ปีที่แล้ว

    Incrível!!!

  • @deivisonvicente8869
    @deivisonvicente8869 2 ปีที่แล้ว

    Pls, share this archive 🤩

    • @maligokmen
      @maligokmen  2 ปีที่แล้ว

      There is a link to the file in the description.

  • @redhaakhund1271
    @redhaakhund1271 2 ปีที่แล้ว

    👍👍👍🙏👍

  • @mylife1131
    @mylife1131 2 ปีที่แล้ว