Convert Excel vba form the Calc

[GaryK4]

To date, I have not found any helpful info.
My spreadsheet has a button that is supposed to bring up a form. (form_name.Show) I get a BASIC runtime error ‘423’ Property or method not found: Show.

• I can double click on the form and display it.
• I fixed the vba code to work with Calc.
  The link between the form and the code does not seem to work ans in Excel

Not sure what to do next. I am trying to migrate from Windows 11 to Linux

[jfn]

Hello Gary,

first of all, I’d completely clean the document from all VBA remnants. Then, reimport valid code chunks (if any).

Unfortunately, the cleaning part is not simple as it can’t be done in the LibreOffice IDE UI. The attached refcard has a chapter on the back that explains how to do that:
LibOBasic_01B_IDE_Flat_A4_EN_v300.pdf (678.1 KB)

When the code is cleaned up, copy back the working code and you’re done.