Issue with Macro/Object since upgrading to Office 2016 from 2010

Hi Everyone,

I am a novice at VBA, and pretty much everything excel related too. I have hopefully a simple problem. I have a staff member that has upgraded her Office from 2010 to 2016. She has an excel workbook that was created like 5+years ago, with a whole bunch of forms and macro's contain within. If I run the macro's manually or click the buttons with the workbook on a computer running Excel 2010 (doesn't need to be her PC) it works perfectly, however when run on Excel 2016, it throws up a "Run-Time error "424" Object required" error.

So far in terms of troubleshooting I have removed a "Missing reference" for "Microsoft Windows Common Controle-2 6.0 (SP6)" and also tried copying and registering the OCX file from a computer running Office 2010 to the 2016 PC. Either option does solve a lot of issues the workbook was having running the Macro's and so forth, but there is one button "Data Entry" that simply wont work. I have also enabled and trusted Macro's in Trust Centre.

It seems my logical brain, that there is something different between Office 2010 and 2016 that is causing this issue.

When I click of Debug, it highlights the following code:

Please Login or Register  to view this content.

When I hover over the Load frmDataEntry which is highlighted in yellow it shows this message:
frmDataEntry = < Object variable or With Block Variable not set>


I don't really know what else to look for or paste here either. I went to edit for the Macro DataEntry and this is the code:

Please Login or Register  to view this content.

Does anyone have any idea what could be causing this? I'd prefer to find a solution rather than downgrading her back to Office 2010, so any help would be greatly appreciated.

Please let me know if you require anything further.

Thanks in advance!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thank you. What code do you have in the Initialize event of the form? If you keep pressing f8 after the error first appears, does the code continue to another error line?

Have you checked to see if there are any MISSING REFERENCES?

Look in: VBE | Tools | References