Calculating Days between Dates using DTPicker Control in Excel VBA

preview_player
Показать описание
This video demonstrates how to calculate the number of days between two dates with the DTPicker control (date and time picker) on an Excel VBA Userform. Calculating years, months, hours, minutes, seconds between dates with the DTPicker control is also reviewed.
Рекомендации по теме
Комментарии
Автор

Thank You. You are always very good.
Todd
How I can format just time when I write four numbers 0400 the system automatically show like 04:00 PM or AM. tks

carlosferreira
Автор

Hi. Dr Todd.
I will ask you about Dates and due dates. I have a invoice system in userform and I want te txtDuedate to show the actual duedate 30 days after the txtInvoiceDate. How can we get that to happen in VBA_
Than you

richardmeborg
Автор

Hello Dr. Todd L. Grande,
I am Chum Ra, Thanks with your sharing important video. any ways please let me ask you about the days that we want calculate in multipage. i follow by your instruction the code can be run one page, if i insert an other page into my userform and write the same of code, i will msg appear like that "the run time error code 35788", so do you have any solution for this problem?
thank you and hope you will be help me to fix its.
with regard

rachum