For Python, VS Code and Jupyter Lab. I used Sublime Text 3 previously but have found VS Code to be easier to set up and better supported over time. I do miss how fast and lightweight Sublime is this compared to VS Code though so I still use ST4 as a general text editor.
For Excel VBA (ugh), pretty much have to use the built in one as there doesn’t seem to be any alternative.