About VBA-UserForms

Pertsa · February 5, 2025, 8:59am

Hello community people!

I came across with a problem, with porting VBA-forms to LibreOffice Basic environment. I have a couple of VBA-forms (MS_Forms) which I’ve exported from a VBA-project in LibreOffice Basic designer as .xdl and then imported to my LibreOffice Basic tuning.
On the main dialog I have a multitab control on which are several controls (such as textboxes, dropdown boxes and so on…). All controls placed on tabs are seen at runtime but are not seen at design mode.

The controls that are seen on design mode can be bound to event routines (sub-programs in the macro) as usual with just a couple of mouse-click. But I haven’t found a way to create an event listener for the controls which are not visible on design mode

I would be very grateful if anyone happens to know a way around this problem and share his/her knowledge with me and others

EDIT: Information in visual form.

The view a runtime:
Screenshot_at_runtime

The view in design mode (edited so that the entire dialog (the controls seen) fits the picture):
Screenshot_on_design_mode

sokol92 · February 5, 2025, 1:52pm

In order to understand, it is probably necessary to upload the original file *.xlsm, then .xdl, .ods.

Villeroy · February 5, 2025, 2:05pm

https://www.pitonyak.org/book/AndrewMacro.odt (Chapter 14 1. »Handlers and Listeners«)

Pertsa · February 5, 2025, 3:23pm

Thanks, but unfortunately the link you provided is dead. I am aware of how the event listener can be built and so on. That’s not the problem, but how to get handle to the controls which are invisible in designer. And foremost, is the tabs object defined in some of UNO service so it can find possible child controls placed on a tabs object. If I can get the handle to these controls I can use a structure (type) and give them properties and then collect all into an array and so on…

Here’s an example of the codebehind my VBA UserForm.