Balloon Object
Description
Represents the balloon in which the Office Assistant displays headings and text information. A balloon can contain controls such as check boxes and labels.
Using the Balloon Object
Use the NewBalloon property to return a Balloon object. There's no collection for the Balloon object; only one balloon can be visible at a time. However, it's possible to define several balloons and call any one of them when needed. For more information, see "Defining and Reusing Balloons" later in this topic.
Use the Show method to make the specified balloon visible. Use the Callback property to run procedures based on selections from modeless balloons (balloons that remain visible while a user works in the application). Use the Close method to close modeless balloons.
The following example creates a balloon that contains tips for saving entered data.
With Assistant.NewBalloon
.BalloonType = msoBalloonTypeBullets
.Icon = msoIconTip
.Button = msoButtonSetOkCancel
.Heading = "Tips for Saving Information."
.Labels(1).Text = "Save your work often."
.Labels(2).Text = "Install a surge protector."
.Labels(3).Text = "Exit your application properly."
.Show
End With
Defining and Reusing Balloons
You can reuse balloons by assigning them to object variables and calling them when needed throughout your procedure. This example defines balloon1, balloon2, and balloon3 as separate balloons, and it displays the balloons at various points in the procedure.
Set balloon1 = Assistant.NewBalloon
balloon1.Heading = "First balloon"
Set balloon2 = Assistant.NewBalloon
balloon2.Heading = "Second balloon"
Set balloon3 = Assistant.NewBalloon
balloon3.Heading = "Third balloon"
balloon1.Show
balloon3.Show
balloon2.Show
You can also combine balloon object variables in an array and index into the array.
Properties
Animation property, Application property, BalloonType property, Button property, Callback property, Checkboxes property, Creator property, Heading property, Icon property, Labels property, Mode property, Name property, Parent property, Private property, Text property.
Methods
Close method, SetAvoidRectangle method, Show method.
Example (Microsoft Access)
See the Assistant object example (Microsoft Access).