get listindex value

[Av8tordude]

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

    With cboYear
        For iloop = Year(Date) - 1 To Year(Date) + 1 Step 1
            .AddItem iloop
        Next
    End With

 

[Fluff]

What do you mean by

How can I get the value of listindex 3.

 

[Av8tordude]

What do you mean by

When I click the dropdown arrow of a combo box, Listindex 3 would display 2022. I would like to get this value.... "2022"

 

[Fluff]

You can use

cboYear.Value

to get the selected value in the combo

 

[Av8tordude]

I think I'm not explaining myself....

when the userform is displayed, the combo box is populated. I would like to get the value (2022) without selecting the listindex. My goal is to check if the current year is not listed in the drop down, clear the combo box and re-populate the combo box with 2020, 2021, 2022, 2023

 

[Fluff]

In that case why not just run the code you posted when the userform initialises.