BalloonCheckbox Object
Description
Represents a check box in the Office Assistant balloon. The BalloonCheckbox object is a member of the BalloonCheckboxes collection.
Using the BalloonCheckbox Object
Use Checkboxes(index), where index is a number from 1 through 5, to return a single BalloonCheckbox object. There can be up to five check boxes in one balloon; each check box appears when a value is assigned to its Text property.
The following example creates a balloon with a heading, text, and three region choices. When the user selects a check box and then clicks OK, the appropriate procedure is run.
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
Select Case True
Case .CheckBoxes(1).Checked
runregion1
Case .CheckBoxes(2).Checked
runregion2
Case .CheckBoxes(3).Checked
runregion3
End Select
End With
Remarks
Balloon check boxes display the user's choices until the user dismisses the balloon. Balloon labels record the user's choice as soon as the user clicks the button beside the label.
Properties
Application property, Checked property, Creator property, Item property (Assistant, BalloonLabel, and BalloonCheckbox objects), Name property, Parent property, Text property.
Example (Microsoft Access)
See the Assistant object example (Microsoft Access).