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:

  • msoBalloonButtonAbort
  • msoBalloonButtonBack
  • msoBalloonButtonCancel
  • msoBalloonButtonClose
  • msoBalloonButtonIgnore
  • msoBalloonButtonNext
  • msoBalloonButtonNo
  • msoBalloonButtonNull
  • msoBalloonButtonOK
  • msoBalloonButtonOptions
  • msoBalloonButtonRetry
  • msoBalloonButtonSearch
  • msoBalloonButtonSnooze
  • msoBalloonButtonTips
  • msoBalloonButtonYes
  • msoBalloonButtonYesToAll

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