Migrating Excel Macro
Migrating Excel Macro
I am trying to migrate an Excel Macro that works with a ListBox Control. The macro fails on the very first statement which is ListBox.Clear. I have not been able to find any documentation related to this. Can someone give me a pointer.
- Hagar Delest
- Moderator
- Posts: 32664
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Migrating Excel Macro
Excel macros are not compatible, language is different. You should search the forum with the "Excel macro" string. Try that one: Can't run a VBA macro from MS Excel file.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Migrating Excel Macro
Since version 2.3 Calc supports dynamic validation, which may be an Excel compatible alternative to listboxes. See attachment.
- Attachments
-
- dynValidation2.3.ods
- New dynamic validation
- (16.54 KiB) Downloaded 11857 times
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Migrating Excel Macro
For examples on (OOo's) listbox handling one can have a look at Basic library "FormWizard" (delivered with a standard installation), which uses SUBs on common tasks (fill, clear, delete first entry, ...); e.g. EmptyFieldsListboxes()
HTH
HTH