ahmed elsery
New Member
- Joined
- Oct 17, 2022
- Messages
- 7
- Office Version
- 2016
- Platform
- Windows
hello guys
so i've made a program on vba
i just need it to full the date on 1st surv date and 2nd surv date and calculate the time left for it
as i've done in sheet but sheet only appears when i search
i want to make it when i write the date in Issue Date text box
auto calculate the date before i even add the client to my sheet
as for example :
Company Name : as
Issue date : 15/2/2022
so the userform auto calculate 1st surv = issue date + 1 year --- time left = 365 day
2nd surv = issue date + 2 years ----- time left = 730 day
expire date = issue date + 3 years ------- time left = 1095 day
is that possible ?
the attached excel sheet is example of how i did it in excel sheet
i want to remove it and textboxes auto calculate
so i've made a program on vba
i just need it to full the date on 1st surv date and 2nd surv date and calculate the time left for it
as i've done in sheet but sheet only appears when i search
i want to make it when i write the date in Issue Date text box
auto calculate the date before i even add the client to my sheet
as for example :
Company Name : as
Issue date : 15/2/2022
so the userform auto calculate 1st surv = issue date + 1 year --- time left = 365 day
2nd surv = issue date + 2 years ----- time left = 730 day
expire date = issue date + 3 years ------- time left = 1095 day
is that possible ?
the attached excel sheet is example of how i did it in excel sheet
i want to remove it and textboxes auto calculate