Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
VBA as my GUI
#1
Photo 
This is my first post on this forum!

30 years ago I was using Superbase 4 and VB5 to build complex GUIs with drag and drop editors. Back then I was on Win 95 and our server hard drive was much smaller than a €4 pen drive today. In the past few years I have moved on to Python and I despair at how primitive the process is now for building such GUIs under Python. In fact I have an application in the field now that uses a VBA frontend in Excel making http calls to Python scripts on a VPS with MySql as the Db. It is just surprising when you have such a wonderful widespread language such as Python with a library for everything that we still have to struggle with the likes of Tkinter.

This is a sample of the GUI under VBA:
buran write Jan-09-2025, 02:24 PM:
attachment removed
Reply
#2
Visually, Tkinter is closest to VBA/Excel Forms
There are plenty of other alternatives to build GUI. You can even go for a web front-end in the browser. There is also option to run Python from Excel using e.g. xlwings.
What is your question?
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
#3
(Jan-09-2025, 08:58 AM)buran Wrote: Visually, Tkinter is closest to VBA/Excel Forms
There are plenty of other alternatives to build GUI. You can even go for a web front-end in the browser. There is also option to run Python from Excel using e.g. xlwings.
What is your question?

Despite my research I still have not found anything as slick as the VBA editor which is as old as the hills, I just put up this post in case I was missing a very obvious competitor.
Reply
#4
I'd like to know too. And I agree...I used VB5/6 back in the day.

Also, if those are real names of people in your screenshot I would erase that and the other personal data. None of those people consented to their info being posted to the world. And, actually, that screenshot isn't even necessary for this discussion.
buran likes this post
Reply
#5
(Jan-09-2025, 02:20 PM)Mike88 Wrote: Also, if those are real names of people in your screenshot I would erase that and the other personal data. None of those people consented to their info being posted to the world. And, actually, that screenshot isn't even necessary for this discussion.
Attachment removed
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
#6
(Jan-09-2025, 02:20 PM)Mike88 Wrote: I'd like to know too. And I agree...I used VB5/6 back in the day.

Also, if those are real names of people in your screenshot I would erase that and the other personal data. None of those people consented to their info being posted to the world. And, actually, that screenshot isn't even necessary for this discussion.

The names in the screenshot are random First Names coupled with random Last Names, in addition all the other data is similarly randomised. I wouldn't put up real data.
Reply
#7
(Jan-09-2025, 03:49 PM)pmulvey Wrote: The names in the screenshot are random First Names coupled with random Last Names, in addition all the other data is similarly randomised. I wouldn't put up real data.

Okay, no worries. Just being concerned for my fellow human beings.
Reply
#8
I see on this page a reference to QtDesigner, which is a GUI app builder. I haven't tried it yet.

https://www.pythonguis.com/pyqt6-tutorial/
Reply
#9
In Linux there is Gambas3, which is very similar to VB.

[Image: gambas3.png]
Reply


Forum Jump:

User Panel Messages

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