Av8tordude
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 1,074
- Office Version
- 2019
- Platform
- Windows
The code below list the three years in a combo box. How can I get the value of listindex 3.
i.e. the code list 2020,2021,2022. I would like to get the value of 2022
i.e. the code list 2020,2021,2022. I would like to get the value of 2022
VBA Code:
With cboYear
For iloop = Year(Date) - 1 To Year(Date) + 1 Step 1
.AddItem iloop
Next
End With