<< Click to Display Table of Contents >> Changing the properties of dropdown lists |
To change the properties of a dropdown list, 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 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 general settings. For more information, see Object properties, Properties tab.
Form object tab
On this tab, you can make settings for the list itself:
▪Lines (max.)
Here you can specify the maximum number of lines to be displayed when the list is opened. |
▪List area
Here you specify the cell range that contains the items to be displayed in the dropdown list. |
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 dropdown list 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 dropdown list is drawn with a 3D effect. |