Hello fellow Excel enthusiast, i need your help
i Have a project that need me to Populate and Verify Data from Master Data(Master Data in Another Single File), but the macro for the "Populate" and "Verify Input" function(we can call it "Form A.xls") was made in 2000(Excel 1997-2003) so we have experienced some bug in current version(365). I can do the Populate and Verify Input perfectly when the VBA Editor is opened and when i close or open the Form A for the first time and click the populate/verify input button it will crash and not responding. maybe someone here experienced the same thing and can help me solve the problem.

Thank you.