BalloonCheckbox Object

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

Remarks

Use CheckBoxes(index), whereis a number from one through five, to return a single BalloonCheckBoxobject. There can be up to five check boxes in one balloon; each check box appears when a value is assigned to its Textproperty. Balloon check boxes display the user's choices until the user dismisses the balloon. You can use balloon labels to return a number corresponding to the user's choice in the Selectmethod as soon as the user clicks the button beside the label. To pass values to the Selectmethod 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. The user selects one or more check boxes and clicks OK. The example calls the specified procedure or procedures.

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

See also:

• Object Model Reference
• BalloonCheckbox Object Members