Your VBA 7.1 x64 installation is missing specific type libraries (e.g., MSCOMCTL.OCX , MSCOMCT2.OCX ), which were 32-bit controls not ported to 64-bit. Solution: Replace legacy ActiveX controls with modern alternatives or run Office in 32-bit mode. Note: Microsoft does not provide 64-bit versions of MSCOMCTL. This is a known limitation. For VBA 7.1 x64, use native UserForm controls or third-party 64-bit OCX files.
It introduces new keywords and compilation attributes to handle 64-bit pointer addresses securely. Architectural Deep Dive: 32-Bit vs. 64-Bit VBA
If you are looking for a standalone programming environment rather than Office automation, consider these official Microsoft tools: