Pop Up Calendar issue with 2030 vs 1930

I have been using some VBA code borrowed from the internet to allow me to select dates from a pop-up calendar.
No matter how I formate the destination cell or make changes to Windows regional settings, any dates from the year 2010 and over are displayed as 1930, etc.
Any suggestions on how to overcome this? I suspect it has something to do with the VBA which I am too much of a novice to work out. Thanks in advance.

Please Login or Register  to view this content.

Hi, I'm only very novice with vba, but maybe try applying the format when settting ThisDay.
e.g. ThisDay = Format(Date, "yyyy/mm/dd")

Thanks. I checked the code thoroughly and changed every instance of yy to yyyy and this finally worked. I should have known this from the start.