Hello,
Thank you for posting in Microsoft Community.
It seems like you are looking for Python IDE. As Python in Excel is currently in preview for Beta Channel Office Insider. If IDE will soon to be available or is available in future update of Excel, you may send a suggestion for this to Excel Team.
For the meantime, you can check this link for free IDE - Visual Studio Python IDE - Python Development Tools for Windows (microsoft.com) for your test or conversion of VBA Code to Python.
Learn more here: Get started with Python in Excel - Microsoft Support
Sincerely,
Kathy A.
Microsoft Community Moderator