I reported this issue to Microsoft in November 2022 and my team at BrightCarbon has been working with the Microsoft VBA team ever since. It looks like a fix has finally been introduced in the 64-bit version of VBE7.DLL as of Version 2402 Build 16.0.17304.20000 (I'm on the beta channel). To check if you have the fix , open this folder:
C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\VBA\VBA7.1
Right click the VBE7.DLL file and check the version in the Details tab as follows:
7.1.11.31 = 35010 issue
7.1.11.33 = 35010 fixed