Thank you. I have a form with 15 textboxes from H1 to H15, along with textboxes 3 for the start date of the instalments and 6 for the payment duration for one instalment per month. As the number of days rises, it is necessary to adjust this code so that the number of months increases starting from the date of the payment.

```For i = 1 To 15
If i = 1 Then
Me("h" & i) = TextBox3.Text
Else
Me("h" & i) = Format(CDate(Me.TextBox3.Value) + i - 1, "dd/mm/yyyy")
End If
Next i```

enter image description here

It is required to modify this code so that the number of months increases from the date of the installment, as it increases the number of days. enter image description here

Feb 3, 2023 in Others 291 views

## 1 answer to this question.

```For i = 1 To 15
If i = 1 Then
Me("h" & i) = TextBox3.Text
Else
Me("h" & i) = Format(DateAdd("m", i-1, CDate(Me.TextBox3.Value)), "dd/mm/yyyy")
End If
Next i```
• 63,420 points

## How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

## Excel-How can I get the address of a cell instead of a value?

There are various difficulties in this. Which ...READ MORE

## Datedif issue - convert number of days to "--Years--Months--Days" format

Try, =DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"Y") & " Years, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"YM") ...READ MORE

## How to return the last n number of values corresponding to a specific category?

Try: The formula in F3: =TAKE(SORT(FILTER(A:C,B:B=F1),1),- ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## Remove formulas from all worksheets in Excel using VBA

Try this : Option Explicit Sub test1() ...READ MORE

## Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE

## Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE