LinkCombo Method

Applies To

DrawingObjects Collection.

Description

Creates a combination list-edit box from a list box and an edit box. The edit box and list box to be linked must be the only two objects in the DrawingObjects collection.

Syntax

object.LinkCombo(link)

object

Required. The DrawingObjects collection.

link

Optional. If omitted or True, the objects are linked so that the edit box text is always updated to the current selection in the list box whenever the user selects a new list box item. If False, the link between the objects is broken.

Remarks

This function is only useful on a dialog sheet, because edit boxes are not allowed on a worksheet or chart. To see how to use the LinkCombo method, use the macro recorder to record creating a Combination List-Edit control on a dialog sheet.

See Also

DrawingObjects Method, EditBox Object, LinkedObject Property, ListBox Object.

Example

This example links list box one and edit box two on Dialog1.


DialogSheets("Dialog1").DrawingObjects( _
    Array("List Box 1", "Edit Box 2")).LinkCombo