Date calculation in userform

[sridharmasi79]

Hi to all, in the userform I'm having many textbox, in that I'm having the following textbox. Date txtbox, Days txtbox, Dues txt box, End date txtbox, like that so on. If I enter the date in date txtbox and in day txtbox as 7 and in dues txtbox as 10 means, I want the value in the end date textbox by automatically calculated in the userform and not in the worksheet and end date txtbox should show me the end date. For example Date 18.08.2017 , it should add the day txtbox value 7days to the date and it should ends on the 10 th week which we give in dues txtbox. And the end date is 27.10.2017

The end date should depends on Date , Days, And Dues txtbox value
Please help me to find this in userform

 

[Warship]

I am not 100% clear on where the Date + Days date should go.
The code below will add the # of days entered in the Dues box to the date in the Date box and put that calculated date in the End box.
You will need to adjust the code to the actual TextBox names you are using in your UserForm.

Me.txtbxEnd = DateAdd("d", Me.txtbxDues, Me.txtbxDate)

 

[sridharmasi79]

TThanks for your help sir