BalloonCheckboxes Object

Note
The Microsoft Office Assistant and AnswerWizard have been depreciated in the release of the Microsoft Office system.

Remarks

Use the CheckBoxes property to return the BalloonCheckBoxes collection.

Use CheckBoxes(index), whereis a number from one through five, to return a single BalloonCheckBoxobject. You can specify up to five check boxes (and five labels) per balloon; each check box appears when a value is assigned to its Textproperty. If you specify more than five check boxes, a run-time error occurs.

Balloon check boxes display the user's choices until the user dismisses the balloon. You can use balloon labels in conjunction with the Select method to return a number corresponding to the user's choice of check boxes as soon as the user clicks the button beside the label. To pass values to the Select method based on the user's choice, you must have the balloon type set to msoBalloonTypeButtons.

Example

The following example creates a balloon with a heading, text, and three region choices. When the user selects one or more check boxes and then clicks OK, the specified procedure or procedures are called.

With Assistant.NewBalloon .Heading = "Regional Sales Data" .Text = "Select your region" For i = 1 To 3 .CheckBoxes(i).Text = "Region " & i Next .Button = msoButtonSetOkCancel .Show If .CheckBoxes(1).Checked Then runregion1 End If If .CheckBoxes(2).Checked Then runregion2 End If If .CheckBoxes(3).Checked Then runregion3 End If End With

Note
You cannot add check boxes to or remove check boxes from the BalloonCheckBoxes collection after the balloon has been displayed.

See also:

• Object Model Reference
• BalloonCheckboxes Object Members