Need to see the code. Probably some place Datevalue() function is used and
wrong year was put in the function.

"PhilM" wrote:

I have created a spreadsheet for data collection which is utilising
userforms for this purpose. The data is for the last financial year
(06-07) and the date options in the combo box reflect this (using
month only) When selected though the year changes to 07 from 06 (ie
April 06 as selected becomes April 07) How can I rectify this?