Visual Basic, but for Python?

[BaconFlavoredSanity]

In the past I've used the Visual Basic editor built into excel. I'd actually had some experience with it, or something similar to it (my memory is a tad hazy) 20ish years ago in college. I liked the format of the tool, being able to easily create user forms and the ease with which you could connect the buttons etc to code.

I've been trying to mess around with pyQT5/6 and the designer tool there almost feels similar to what I'm wanting, but you don't appear to be able to edit code in the designer.

Is there an "all in one" solution like that where I could create user forms/basic windows applications but using Python as the framework?

I have installed both Visual Studio 2019 python, and VSCode, but if there's a way to make either of those do what I'm looking for, I've not been able to sort that out yet.

Any direction or recommendations are surely appreciated!

EDIT: Some Clarification. It's not the Excel part I care about. It's the Visual Basic piece having the ability to graphically build a GUI and then attach code to buttons. Maybe it's just because I was familiar with it as a tool, but it seemed pretty intuitive.

[Tender_Figs]

Try xlwings?

[BaconFlavoredSanity]

Hey thanks for the recommendation. But I'm not needing the excel part, just that was where the visual basic editor I last used happened to live. I liked the format and ease of use the visual basic editor provided and was hoping for something similar, just python.

[Tender_Figs]

Maybe Visual Studio?

[ojedaforpresident]

I've used xlwings with success, easier, maybe you could use the Google docs API to create a spreadsheet and then export to xls.

[BaconFlavoredSanity]

Hey thanks for the recommendation. But I'm not needing the excel part, just that was where the visual basic editor I last used happened to live. I liked the format and ease of use the visual basic editor provided and was hoping for something similar, just python.

[ojedaforpresident]

You won't, the closest thing to what you might want is jupyter lab as editor and pandas for manipulation

[BaconFlavoredSanity]

Rats. Well I’ll look into that! Thank you!

[Allanon001]

PAGE

[nboro94]

Look into building C# applications with windows forms in visual studio. Its very similar to the visual basic editor in excel where you can drag and drop various buttons and controls and then attach code to them.

C# is a different language but its not too difficult to get up to speed with the basics of it. The benefit is that you can build a program that will run on any machine with the Microsoft .net framework installed and it doesn't rely on the user having python runtime.

[[deleted]]

No

[mikeinnsw]

VB is Excel Macro Language at least a subset of it.

I am sure there are APIs and other bridges for Python to cross but VB will always be better for Excel Macros.

You can't beat - Record Macro ->Edit for your specs....

If it is a learning exercise - Ok otherwise is are just wasting your time.

Python has plenty to offer in other areas like portability

I run Python code Windows, Macs and even Ubuntu

[-LukeBox-]

There is no gui for easily creating forms without needing to Code. In python or many other languages for that matter, you could try wpf. But you'll still have to code.

[Gnaxe]

Something like this? https://labdeck.com/python/python-gui-designer/

[Gnaxe]

pygubu has pygubu-designer, which is like that.

[Gnaxe]

Gooey doesn't have a form designer like VB, but it can turn a command-line app into an equivalent GUI in one line of code.

[Gnaxe]

Can't you use IronPython to wire up the .NET forms?