ricafonyat
New Member
- Joined
- May 1, 2017
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
My userform has 10 textboxes with the following names:
TB_Year1
TB_Year2
TB_Year3
TB_Year4
TB_Year5
TB_Year6
TB_Year7
TB_Year8
TB_Year9
TB_Year10
And I have two named ranges in my worksheet("Sheet1")
Range1 --- > firstYear example: 2022
Range2 --- > totalYears example: 5
My goal is to fill the TB_Year1 with the value of the FirstYear and the rest adding 1 year until totalYears
Any help would be appreciated
TB_Year1
TB_Year2
TB_Year3
TB_Year4
TB_Year5
TB_Year6
TB_Year7
TB_Year8
TB_Year9
TB_Year10
And I have two named ranges in my worksheet("Sheet1")
Range1 --- > firstYear example: 2022
Range2 --- > totalYears example: 5
My goal is to fill the TB_Year1 with the value of the FirstYear and the rest adding 1 year until totalYears
Any help would be appreciated