I'd like to have a drop down box with various years in one cell 2000, 2001,
2002 etc) linked to another cell which would display the year.

I can't find a drop down box in forms, but I found a "list box"

For "input range" I clicked a column containing 2000, 2001, 2002, etc

For "cell link" I clicked on a cell called "year" where I want it displayed.

I've tried numerous "format cell" maneuvers, ie setting original date cells
as text, numeric, date, custom date "yyyy". If I format it as regular date,
of course, the 2000 gets converted to date in the usual manner. Is there a
way to tell excel that "1999" is purely the year, ie no day or month. I tried
all combinations.

However, no matter what I do, if I click on 2000 (first in the list), 1 is
displayed in the "cell link". If i click on 2001 (second in lits), 2 is
displayed.

I have a calendar spreadsheet with a cell called "year" that changes the
calender automatically, but currently you need to type the year in. What I
want is to intruduce a drop down box that would send the result to that sell.
I can use a "spinner" function and set minimum and maximum numbers etc, and
the correct number is transferred and the calendar works, but I can't get it
working with "list box". Thanks. Is there a drop down box option as well.