If you are unable to see the toolbox at the bottom of the screen, select from menu: View -> Toolbars -> Toolbox. For this tutorial, add a textbox and a button.

Select a control and drag your mouse inside the Dialog to place your desired control. The controls are placed at the bottom of the screen. For simplicity, I would add a textbox and a button. On the same LO Basic Macro Organizer, click EDIT while Dialog1 is selected.Įntire Dialog editor would open inside LO Calc.

You can see the Dialog1 is come up under My Dialogs -> Standard -> Dialog1. For this tutorial, lets keep it as default Dialog1. On the New Dialog pop-up, give a name to your dialog. Once above options is chosen, below LO Basic Macro Organizer would open.

To add a Dialog in LibreOffice Calc, select from menu: Tools -> Macros -> Organize Dialogs… Also it covers on how to read the control values using Calc Macros. This tutorial will cover on how to create a basic LibreOffice Dialog and adding various controls such as TextBox.

Openoffice calc find and replace