Тёмный

Date and Time Picker Control on a Userform in Excel VBA 

Dr. Todd Grande
Подписаться 1,5 млн
Просмотров 70 тыс.
50% 1

This video demonstrates how to use the Date and Time Picker control on an Excel VBA UserForm. In this example the Date and Time Picker control is used to allow the user to populate the active cell with the date and time in a custom format.

Опубликовано:

 

14 июл 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
@jaysoni3674
@jaysoni3674 7 лет назад
Thanks a ton :)
@DrGrande
@DrGrande 7 лет назад
You're welcome, thanks for watching -
@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
@DrGrande
@DrGrande 6 лет назад
Thank you!
@user-eu2fr2hi6l
@user-eu2fr2hi6l 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.
@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?
@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 ?
@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
@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
@allabout1135
@allabout1135 6 лет назад
Would be more useful if its polulating the cell than continue polulating automaticaly cell below.
@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.
Далее
[RU] Winline EPIC Standoff 2 Major | LAN | Final Day
9:48:47
How to make your Excel VBA code run 1000 times faster
16:55
UserForm with Multiple Option Buttons in Excel and VBA
18:33
Create Event In Outlook Calendar From Excel VBA
6:33
Mini Calendar Add-In for Excel and a little VBA code
8:25
VBA to BROWSE & COPY Data from SELECTED File in Excel
10:00
Add a Clock to a UserForm using Excel VBA
10:30
Просмотров 24 тыс.
Date picker for Excel with VBA code
23:34
Просмотров 127 тыс.