<< 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 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. |