Show Method
Applies To
Balloon object, FileFind object.
Description
Balloon object: Displays the specified balloon object. Returns an msoBalloonType constant that indicates which balloon the user clicks.
FileFind object: Displays the Find File dialog and the current search criteria. Macintosh only.
Syntax
expression.Show
expression Required. An expression that returns a Balloon object or a FileFind object.
Remarks
For the Balloon object, you can use the return value of the Show method to display a user's button selection. The Show method returns one of the following MsoBalloonType constants:
See Also
Balloon object, BalloonCheckboxes collection object, NewBalloon property.
Example
This example creates a balloon containing three choices. The variable x is set to the return value of the Show method, which will be 1, 2 or 3, corresponding to the label the user clicks. In the example, a simple message box displays the value of the variable x, but you can pass the value to another procedure, or you can use the value in a Select Case statement.
Set b = Assistant.NewBalloon
With b
.Heading = "This is my heading"
.Text = "Select one of these things:"
.Labels(1).Text = "Choice One"
.Labels(2).Text = "Choice Two"
.Labels(3).Text = "Choice Three"
x = .Show
End With
MsgBox x