Date picker inoperation in Win 8.1

Question

0

Sign in to vote

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

Tuesday, December 03, 2013 4:16 AM

Reply

|

Quote

|

All replies

0

Sign in to vote

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, that’s why it doesn’t work.

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

Thanks for your understanding.
Kate Li
TechNet Community Support

Wednesday, December 04, 2013 6:46 AM

Reply

|

Quote

|

Moderator

0

Sign in to vote

Thanks Kate. I'll give it a try.

Thursday, December 05, 2013 4:03 AM

Reply

|

Quote

|

0

Sign in to vote

Hi,

Any update on your issue?

Have you spared time to change the VBA code to fix this issue?
Kate Li
TechNet Community Support

Tuesday, December 10, 2013 1:49 AM

Reply

|

Quote

|

Moderator