Dialog

Inserts a dialog box control into the spreadsheet. Dialogs contain special cells that are not visible in the spreadsheet (beginning at row 400).

Dialogs may contain text and values, and selected Graphics controls, Math, Text String, Input/Output, Clocked Data Storage and Vision Data Access functions. For more information, see Controls Functions, Math, String Functions, Input/Output Functions, Clocked Data Storage Functions, or Vision Data Access Functions.
Up to 20 dialogs can be inserted into a spreadsheet, and multiple dialogs can be linked together by a Wizard function. For more information, see Wizard.
Dialogs can be executed either manually by the user or automatically when referenced via the Select function. For more information, see Select.

Note:

By default, dialog cells are not visible in the spreadsheet. To view the dialog cells, you need to enable the View Entire Spreadsheet option (Menu > View Entire Spreadsheet).
By default, all Dialog functions within the job will contain a Cancel button. To exclude the Cancel button from the Dialog, disable the Allow Cancel in Dialog Function Sensor menu option. For more information, see Sensor Menu: Spreadsheet View.
To access the property sheet for a Dialog, right-click the dialog control and select Edit Function. For more information, see Property Sheet.
A Dialog control that is copied cannot be pasted into multiple cells.
When pasting a Dialog, all cell references will become absolute cell references. For more information, see Cell References - Relative/Absolute
When pasting a Dialog from one job into another job, the Dialog control is copied, but the contents of the Dialog are not copied.
Charts are not supported in Dialogs. For more information, see Chart.
If a button (e.g. OK, Next, Cancel) within a Dialog has the same location as the cell where the Dialog was launched, releasing the mouse click activates the button within the Dialog. An alternative is to either increase or decrease the height of the Dialog by one cell or to launch the Dialog by highlighting the cell and pressing the ENTER key.
When a Dialog function's Dialog Title parameter references a cell that contains an editable string value (e.g. EditString, ListBox or Concatenate) within the Dialog (using a GetString function, if necessary), and the cell's value is changed, the cell is updated immediately to show the new value. However, the Dialog Title still shows the old value. The Dialog Title will be updated when the Dialog is re-opened. In addition, if the Dialog is referenced by a Wizard function whose Mode is set to 1 (Sequential), the Wizard Menu still shows the old value after changing the cell's string value. The Wizard Menu will be updated when the Wizard is re-opened.

Dialog Inputs

Syntax: Dialog (Label,Dialog Title,High,Wide)

Parameter	Description
Label	The name that will appear in the spreadsheet.
Dialog Title	The name that will appear in the dialog's title bar (up to 39 characters).
High	Specifies the height of the dialog, in number of cells (1 to 20; default = 5).
Wide	Specifies the width of the dialog, in number of cells (3 to 10; default = 5).

Dialog Outputs

Returns	A value of 1 when the dialog is on display; otherwise returns 0.
Results	A labeled Dialog control.

Dialog Example

A spreadsheet is configured as follows:

A4 = Dialog("Test","Test Dialog",5,5)

Clicking on the Dialog control in cell A4 displays the following dialog:

You may now insert text labels, numeric values, and formulas into the dialog as you would into the spreadsheet.

Dialog Menu Bar Options

File Menu Options	Related Topic
Import Cells	Import/Export Cells Dialog
Export Cells	Import/Export Cells Dialog
Page Setup	Page Setup Dialog
Print Preview	Print Preview
Print	Print Dialog
Edit Menu Options
Undo	Edit Menu: Spreadsheet View
Redo	Edit Menu: Spreadsheet View
Cut	Edit Menu: Spreadsheet View
Copy	Edit Menu: Spreadsheet View
Paste	Edit Menu: Spreadsheet View
Clear	Edit Menu: Spreadsheet View
Find	Edit Menu: Spreadsheet View
Go To...	Edit Menu: Spreadsheet View
Cell Graphics	Edit Menu: Spreadsheet View
Maximize Region	Edit Menu: Spreadsheet View
Cell State	Cell State Dialog
View Menu
Toolbars (Standard Toolbar, Formatting Toolbar, Job Edit Toolbar, Formula Bar)	Toolbars: Spreadsheet View and Spreadsheet Cell Execution and Editing Reference
Grid Lines
Insert Menu
Function	Insert Function Dialog
Absolute Reference	Cell References - Relative/Absolute
Relative Reference	Cell References - Relative/Absolute
Comment	Comment Dialog
Symbolic Tag	Symbolic Tag Editor
Format Menu
Cells	Format Cells Dialog
Rows (Row Height, Auto Fit)	Row Height Dialog and Format Menu
Columns (Column Width, Auto Fit)	Column Width Dialog and Format Menu

Dialog Toolbar Buttons

Button	Function
	Print
	Print Preview
	Cut
	Copy
	Paste
	Undo
	Redo
	Find
	Bold
	Italicize
	Align text to the left
	Align text to the center.
	Align text to the right.
	Increase the number of decimal places.
	Decrease the number of decimal places.
	Background color. For more information, see Format Cells Dialog.
	Foreground color. For more information, see Format Cells Dialog.
	Absolute cell reference. For more information, see Cell References - Relative/Absolute.
	Relative cell reference. For more information, see Cell References - Relative/Absolute.
	Insert Function dialog. For more information, see Insert Function Dialog.
	Cell Graphics
	Maximize Region
	Cell state. For more information, see Cell State Dialog.
	Comment. For more information, see Comment Dialog.
	Symbolic Tag. For more information, see Symbolic Tag Editor.
	Accept the current modification
	Cancel the current modification and restore previous values (if any)
	Formula Bar. For more information, see Spreadsheet Cell Execution and Editing Reference.