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 (e.g. by clicking with the right mouse button) and select Form object: Properties from 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 Single option here.
The other options Multi and Extended allow multiple items to be selected in the list box, but return nothing to the result cell. They are only offered for compatibility with Excel.

List area

Here you specify the cell range that contains the items to be displayed in the listbox.
If, for example, you fill the cells F5 through 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 listbox should be returned.
The result cell displays which entry in the list 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.