Gets the BalloonCheckboxes collection that represents all the check boxes contained in the specified balloon. Read-only.
| Note
|
| The Microsoft Office Assistant has been deprecated in the release of the Microsoft Office system. |
Syntax
expression.Checkboxes
expression A variable that represents a Balloon object.
Example
This example creates a balloon with a heading, text, and three region choices. When the user clicks OK in the balloon, data for the selected region or regions is printed.
| Visual Basic for Applications
|
With Assistant.NewBalloon .Heading = "Regional Sales Data" .Text = "Select the region(s) you want to print." For i = 1 To 3 .CheckBoxes(i).Text = "Region " & i Next .Button = msoButtonSetOkCancel If .Show = msoBalloonButtonOK Then dataPrinted = 0 For i = 1 To 3 If .CheckBoxes(i).Checked = True Then ' Code to print region data. dataPrinted = dataPrinted + 1 MsgBox "Region " & i & " data printed." End If Next If dataPrinted = 0 Then MsgBox "No data printed." End If End With
|
checkboxes checkboxes property find all checked boxes within a balloon ofv reveal within a balloon all boxes checked select all checkboxes in a specific balloon view collection of all boxes checked in a balloon
See also:
Note