Page 1 of 1

Migrating Excel Macro

PostPosted: Tue Jan 29, 2008 7:13 am
by jb101
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.

Re: Migrating Excel Macro

PostPosted: Tue Jan 29, 2008 11:38 pm
by Hagar Delest
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.

Re: Migrating Excel Macro

PostPosted: Wed Jan 30, 2008 12:36 am
by Villeroy
Since version 2.3 Calc supports dynamic validation, which may be an Excel compatible alternative to listboxes. See attachment.

Re: Migrating Excel Macro

PostPosted: Wed Jan 30, 2008 12:02 pm
by probe1
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