In Excel 2002 in Windows 7, I had a spreadsheet that included a user form that comprised 4 input fields, including date picker. I  upgraded to Excel 2010 and the spreadsheets (the VBA code used) did not work at all. So, I continued using them with Excel 2002. Then I upgraded to Windows 8, using Excel 2002 and the spreadsheets and VBA code still worked. I upgraded to Win 8.1 and the date picker input field of the user box now does not exist.

What can I do to recover the date picker input field?

many thanks

surferOG

Hi,

This issue is caused by compatibility.

You can refer to this link:

http://www.microsoft.com/en-us/windows/compatibility/CompatCenter/ProductDetailsViewer?Name=Microsoft%20Office%20Excel%202002&vendor=Microsoft&Locale=1033%2C2057%2C3081%2C4105%2C16393&ModelOrVersion=10&BreadCrumbPath=excel%202002&LastSearchTerm=excel%2B2002&Type=Software&tempOsid=Windows%208.1

It appeared that Microsoft Office Excel 2002 is not compatible with Windows 8.1, thats why it doesnt work.

You may need to upgrade your office excel and change your VBA code to fix this issue.

Thanks for your understanding.

Thanks Kate. I'll give it a try.

Hi, 

Any update on your issue?

Have you spared time to change the VBA code to fix this issue?