Showing Dialogs in Calc Spreadsheet

I am attempting to convert a Visual Basic application developed on a Windows 2K version of Excel. This uses macros to display the forms and perform the calculations, backed up by spreadsheets which hold the static data and text that populates the form fields.

I have been able to create dialog boxes with buttons, lists, etc., but am struggling to find out how one embeds dialog boxes in a worksheet for the user interface.

I understand, of course, that much of the original macro code will have to be rewritten, but if I am not able to get this part to work there’s little point in continuing.

I am running on a SUSE Linux 5.9 platform with LibreOffice Thanks for your help.

I don’t know what a dialog box is, but dialogs aren’t graphical objects which can be inserted into documents. Dialogs are displayed in modal windows, and I don’t know a way to use them differently.

However, you can compose something looking similar by grouping form controls. A button e.g. intended to be used only as a kind of background / panel may be disabled, have no label, be colored differently… and may look like the backgroung of a kind of dialog then. The same way you can play with labels, group boxes, …
You can also group form controls with ordinary shapes…

Have a lot of fun!

Apologies for the apparent confusion over the use of the term dialog boxes. They were called dialog sheets in VBA and LO uses the term dialog. VBA had a neat way of showing each dialog sheet in the bottom bar in the same way as a normal worksheet. I was therefore hoping that LO had a simpler way of showing dialogs than the convoluted method of presentation that I’ve found. It makes it very difficult to build a uniform looking interface for several different forms.