Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
VBA user learning Python
#1
Hey all..

I used VBA in excel really extensively in my work. Automating graphs and manipulating data in excel.
It's kinda where I started to understand and use a language to help with my tasks.
I'm noticing a lot of similarities between VBA and Python. Loops, variables,etc. But the one thing I liked about VBA is that I could step through a process hitting F8. If I referenced or selected, for example, another excel tab or even a webpage. I would see exactly what was going on on the screen. If I selected a different tab in VBA, using F8 I would see the tabs change as the code instructed. This really helped me learn what to do.
I was even able in hover my mouse over variables in VBA to see what string was being held in that variable.

Is there any editor or IDLE that does the same thing?
Where I can step through each line of code and it will show what the code was performing.
But with the python IDLE this doesn't seem to be an option.

Any advice would be appreciated! Big Grin
Reply
#2
IDLE is poor editor.
List of python IDEs

Many of us on the forum use VSCode and I would recommend it. It has Debug functionality
Check https://python-forum.io/Thread-VS-Code-from-start


Other popular choice is PyCharm [community editon is free)

If you search the forum there are plenty of discussion on IDE choice
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020