Changing the properties of listboxes

<< Click to Display Table of Contents >>

Changing the properties of listboxes

To change the properties of a listbox, select it (for example, by right-clicking on it) and choose Form object: Properties in the context menu.

Alternatively: On the contextual ribbon tab Object, click on the group arrowgroup_arrow in the bottom right corner of any command group.

The program displays a dialog box with the following options:

Format tab

On this tab, you can change the size and positioning of the object. For more information, see Object properties, Format tab.

Properties tab

On this tab, you can change some general settings. For more information, see Object properties, Properties tab.

Form object tab

On this tab, you can make settings for the list itself:

Selection type

You should always use the option Single here.
The other options Multi and Extended allow multiple items to be selected in the list, however, no result is then output in the result cell. They are only provided for compatibility with Excel.

List area

Here, you specify the cell range that contains the entries to be displayed in the list.
If, for example, you fill the cells F5 to F7 with the values "dog", "cat" and "mouse" and enter F5:F7 in the list area, those three values will appear in the list.

Result cell

Here, you specify to which cell the result of the list should be returned.
The result cell displays which of the list entries is selected. When the first entry is selected, 1 appears. When the second entry is selected, 2 appears, etc.

Appearance section

Here, you can specify the character format (font, size, color, etc.) for the text.

3D effect

If you enable this option, the list will be drawn with a 3D effect.