Excel VBA UserForm TextBox - How to format date

Поділитися
Вставка
  • Опубліковано 15 вер 2024

КОМЕНТАРІ • 30

  • @yadwendraray9522
    @yadwendraray9522 5 років тому +3

    Great, you are teaching very deeply with all suitable examples. Thank you 😄

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

    Well presented. Simple and effective. Thank you very much for sharing.

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

    really this is the best solution thank you thank you for helping me i wish you the best and all your dream come true

  • @offshoreengineerguide5920
    @offshoreengineerguide5920 6 років тому +1

    Thank you so much. Very straightforward. That's what I exactly need.

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

    Thank you for very useful short video

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

    thanks for your effort video its helps me🙏👍

  • @AndersonVargasFR3UD0Z3R
    @AndersonVargasFR3UD0Z3R 7 років тому

    Excelente, no hablo ingles pero te entendí a la perfección, gracias (Thank you)

  • @JosephArouna
    @JosephArouna 7 років тому +1

    Thanks for your tutorial. It's very interesting. But what about"hours" and "minutes" ? For example in a start hour and an end hour.

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

    THANK YOU SO MUCH MAM

  • @carlosferreira7747
    @carlosferreira7747 7 років тому

    Thank you.
    Are you able to show us: How to Format Date on textBox and when is filled up skip to the next textBox?

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

    Thanks for you.....

  • @zada555
    @zada555 5 років тому

    Thanks a lot, very usefull

  • @dramannia
    @dramannia 8 років тому +1

    Thank U so Much!!!!

  • @IGNACIOIC
    @IGNACIOIC 8 років тому

    THANK YOU VERY MUCH

  • @kaaa3485
    @kaaa3485 5 років тому

    I have another question, how to change the color of a cell based on empty or has data? if the cell has data, no color but if the cell is blanck, color the cell. Thanks.

  • @karima_MK
    @karima_MK 8 років тому

    Thank you. I would like to modify the date. When I insert it, I need sometime to write a day before or after but no change is alloed. Thanks

  • @balasubramaniamgopal8437
    @balasubramaniamgopal8437 8 років тому

    Hi, this video is too good to get the date and time. But still I need some more changes in my userform. Could you help !!
    I want the present time to displayed on the userfrom on a Click and in this format "Thursday, Jun 16, 2016 15:42 EST "

  • @alejomunoz12
    @alejomunoz12 7 років тому

    Thanks!!!

  • @leslinks
    @leslinks 7 років тому

    v useful
    thanks :-)

  •  5 років тому

    thank !

  • @seckinbilgic
    @seckinbilgic 6 років тому

    Eline sağlık

  • @matconsthoward8074
    @matconsthoward8074 7 років тому

    thank

  • @wadjets
    @wadjets 9 років тому +1

    Hi, what if I want the format but writting myself the date in the textbox, so that if
    I type 03312015, it automatically fills Mar/31/2015 inside the textbox

    • @karima_MK
      @karima_MK 8 років тому

      Did you find your answer ? I am curious about it, I could make a use of this code too.

    • @wadjets
      @wadjets 8 років тому +1

      K K actually I didn't, I had to create a popup message to advice the required format, didn't dig in to it much since it wasn't a critical matter. I suggest you ask in MrExcel.com they've solved pretty much all of my questions

  • @JosephArouna
    @JosephArouna 7 років тому

    Hello ! How can I get dates from worksheet into Userform TextBoxes (not current date) ?

    • @innocentobie5327
      @innocentobie5327 6 років тому

      if your date is in cell B4 for example, and you want to display it on TextBox1
      TextBox1.Text = Sheet1.Range("B4").Value

  • @ignacio4535
    @ignacio4535 5 років тому

    Hello, how about in another language?

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

    Keeping code blurred has made it of no help.

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

    Can u type properly please.