LOOP year

User avatar
sal21
PlatinumLounger
Posts: 4420
Joined: 26 Apr 2010, 17:36

LOOP year

Post by sal21 »

Code: Select all

With Me.CANNI
        .Clear
        For K = Year(Date) - 1 To Year(Date)
            .AddItem K
        Next K
    End With
how to have instead
2021
2022

this

2022
2021

User avatar
HansV
Administrator
Posts: 78863
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: LOOP year

Post by HansV »

Code: Select all

        For K = Year(Date) To Year(Date) - 1 Step -1
Best wishes,
Hans