Date and Time Picker Control on a Userform in Excel VBA

Поделиться
HTML-код
  • Опубликовано: 6 окт 2024

Комментарии • 15

  • @robertodonati1037
    @robertodonati1037 7 лет назад

    Thank you Dr Grande for a very easy to follow and understand video.

    • @angelinastanton7996
      @angelinastanton7996 6 лет назад

      I'm glad you found this easy to understand! I wish this came easy to me because I struggle with understanding many of the videos for Excel VBA

  • @مرغنيكمال-ش3ث
    @مرغنيكمال-ش3ث 6 лет назад

    Thanks Dr. for this wonderful explanation. I have a problem with the additional controls tool when I click on them, nothing happens. Knowing that I have a copy of Office 2016 32-bit and Windows 10 64-bit system

    • @angelinastanton7996
      @angelinastanton7996 6 лет назад

      Although I did not like the video, I agree that Dr. Grande was very thorough in walking us through the steps to take. It would take me a lot of studying to memorize some of them.

  • @vasanthviswa7295
    @vasanthviswa7295 4 года назад

    Thanks Dr, is there a way i can select the date and keep and when i click on submit i can get the date, by following your video i had created nearly 9 datepicker and 9 commandbuttons and used activecell offset accordingly, also i have followed your few vids and used active cell as the first ref, so i have to cautiously select the cell and run the vba is there a way to directly select the first cell of every row where data needs to be filled instead of me selecting, and once again Thankyou so much

  • @oslcparksville
    @oslcparksville 6 лет назад

    Good video

  • @sanehdeepsingh2526
    @sanehdeepsingh2526 5 лет назад

    Very useful but my form to dates
    But it met except null date(empty)
    I have to enter any date to avoid error
    Kindly suggest how to use date picker blank

  • @jaysoni3674
    @jaysoni3674 7 лет назад

    Thanks a ton :)

    • @DrGrande
      @DrGrande  7 лет назад

      You're welcome, thanks for watching -

  • @renukavashisth6744
    @renukavashisth6744 4 года назад

    Sir I have a question I want to copy one date to next date then copy next date until another date in loop
    Like in A1 I have 01/05/2020 & in A10 I have 02/05/2020 & A12 I have 03/05/2020. Now I want to fill dates in cell A2 to A9 date 01/05/2020 so on dates are not in same position
    Plz help me

  • @ahmedhesham-km2zl
    @ahmedhesham-km2zl 5 лет назад

    how to make choosing time in the same userform but seperate from the date and affecting the same cell as well ?

  • @javierreyna5321
    @javierreyna5321 5 лет назад

    How can I modify the value that always appears TODAY in the current value when the user want to select the date?

  • @angelinastanton7996
    @angelinastanton7996 6 лет назад

    The steps in this video were extremely confusing for me to watch. I am not a fan of Excel VBA because most of the videos using this program are confusing. However, the finalized table was very simple to read. I think that SPSS is a bit easier to navigate most of the time.

  • @allabout1135
    @allabout1135 6 лет назад

    Would be more useful if its polulating the cell than continue polulating automaticaly cell below.