[Macro] help for beginner

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
stepha
Posts: 1
Joined: Wed Dec 09, 2020 8:38 pm

[Macro] help for beginner

Post by stepha »

Hi,

I know this is a beginner question
I know a bit of VBA and application under excel

I've read a lot about things more or less linked to my problem

The problem is really simple :
I have a form with 15 texbox
I wanna be sure none of the 15 textboxes are empty
I don't wanna use 15 if

Once again, it's a beginner question, and I have read a lot but I cannot figure how to deal it

I've tried to do a simple function I call to check if strings are empty (passed as parameters) but it seems the function only take the first one into account

Well
If there is a bit of code already done I can study to understand, or if someone can explain me how to pass 15 strings from 15 textboxes to my empry_string test function, thanks a lot !

Steph
openoffice 4.1.8
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Macro] help for beginner

Post by Villeroy »

OpenOffice has a database component which is the natural environment for input forms. Forget all your VBA knowledge, particularly if it is limited to copy/pasted code and the macro recorder (most "VBA knowledge" is on that level). Use Excel forever or leave behind all that spreadsheet bullshit.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply