Your partner for outstanding OpenOffice, EXCEL and VBA applications.
This web site is brought to you as a public service by Herve Hanuise and Affordable Solutions.
We provide complete consulting and custom application design and development for Excel and OpenOffice Calc.
For more information about how to turn Excel into a powerful application platform, contact us at firstname.lastname@example.org
I can show you how to do it, help you do it or I can do it for you
It is your choice
Each time you start with a new program, you have to reconsider EVERYTHING : so let it be with OOoBasic !
To enter my very first code, I tried to open some editor : googled and found
The Basic editor and debugger of the IDE window is shown when the user edits a Sub or Function from the Tools - Macros - Organize Macros - OpenOffice.org Basic dialog.|
In this mode, the window contains the actual editor main window, debugger Watch window to display variable values and the debugger Calls window to display the Basic call stack.
The editor supports common editor features. Since the editor is only used for the OpenOffice.org Basic programming language, it supports a Basic syntax specific highlighting and F1 help for Basic keywords.
From there on, as I wanted to program a simple dialog requesting an answer from the user, I went on googling further :
1. - Choose Tools - Macros - Organize Dialogs, and then click New.|
2. - Enter a name for the dialog, and click OK.
- To rename the dialog later, right-click the name on the tab, and choose Rename.
3. - Click Edit. The Basic dialog editor opens and contains a blank dialog.
4. - If you do not see the Toolbox bar, click the arrow next to the Insert Controls icon to open the Toolbox bar.
5. - Click a tool and then drag in the dialog to create the control.
... and :
Be consistent with uppercase and lowercase letter when you attach a control to an object variable.
1. - Global Function for Loading Dialogs
2. - Displaying a Dialog
3. - Read or Edit Properties of Controls in the Program
4. - Add an Entry to a ListBox
5. - Remove an Entry from a ListBox
6. - Related Topics
The most important source is :
This work is licensed under a Creative Commons Attribution 4.0 International License.
Affordable Solutions is an independent consultancy based in Soignies, Belgium, owned and run by Hervé Hanuise, specialising in application development using the Microsoft Office suite.
A graduate of Benton Harbor University, Hervé has a M.Sc. in Engineering, Economics and Management, providing a unique blend of both business and technical skills.
He is one of a handful of people worldwide to have a good 35 years of expertise in Excel & VBA.
Affordable Solutions aims to provide a number of helpful and interesting utilities, examples, tips and techniques to help in your use of Excel and development of Excel solutions.