how can I use python in Microsoft excel??

Question

I code in VBA through an internal developer within MS excel, but have no clue how to execute the code in Excel.

Answer 1

You cannot execute python code inside Excel, at least not yet. There are some rumors that Microsoft considers the possibility for the future... But I am not sure how serious this is. Microsoft has its own ecosystem of programming languages so I would find it really surprising if they actually gave preference to a third party open source option instead of e.g. C# or Typescript.
https://www.bleepingcomputer.com/news/microsoft/microsoft-considers-adding-python-as-an-official-scripting-language-to-excel/

However there are ways to read and write Excel files from a python program, using external libraries like openpyxl or pandas