Looking for help in vba with combobox lists

[MATTHEWABEN]

CODE IS AS FOLLOWS:

'CLEAR PULLDOWN LIST FOR SELECTION YEAR
UCD_SELECTIONYEAR.Clear

'RESETS YEAR SELECTION LIST
Do
With UCD_SELECTIONYEAR
.AddItem UCDSEL_YEAR
End With
COUNTER_A = COUNTER_A + 1
UCDSEL_YEAR = UCDSEL_YEAR - COUNTER_A
Loop Until UCDSEL_YEAR <= 1990

THE GOAL WAS TO DISPLAY A YEAR STARTING AT 2016 AND ENDING AT 1990. CURRENT OUT PUT IN LIST IS 2016,2015,2013,2010,2006,2001,1995.

IF POSSIBLE THE BEST RESULT WOULD BE A LOOP THAT OUTPUT VALUES FOR EACH YEAR FROM 1990 TO CURRENT SELF UPDATING CHECKING AGAINST COMPUTER CLOCK.

PLEASE LET ME KNOW WHERE I WENT WRONG I AM NEW HERE, ALSO NEW CODER, AND NEED HELP.

THANKS IN ADVANCE
MATTHEW,

[LeoTaxi]

could be like this

Please Login or Register  to view this content.

Kind regards
Leo

[MATTHEWABEN]

Thank leotaxi I found my stupidity with the counter_a increasingly decreasing my year output.

removed counter_a and am now running a loop with ucdsel_year = ucdsel_year -1