Balloon.Close Method - Microsoft Office Excel

Syntax

expression.Close

expression A variable that represents a Balloon object.

Example

This example displays a balloon that contains a button for each of three printers. Whenever the user clicks one of these buttons, the ProcessPrinter callback procedure is run and the balloon is closed.

Visual Basic for Applications

Visual Basic for Applications
Sub selectPrinter() Set bln = Assistant.NewBalloon With bln .Heading = "Select a Printer." .Labels(1).Text = "Network Printer" .Labels(2).Text = "Local Printer" .Labels(3).Text = "Local Color Printer" .BalloonType = msoBalloonTypeButtons .Mode = msoModeModeless .Callback = "ProcessPrinter" .Show End With End Sub Sub ProcessPrinter(bln As Balloon, lbtn As Long, _ lPriv As Long) Assistant.Animation = msoAnimationPrinting Select Case lbtn Case -1 ' Insert network printer-specific code. Case -2 ' Insert local printer-specific code. Case -3 ' Insert color printer-specific code. End Select bln.Close End Sub

Sub selectPrinter() Set bln = Assistant.NewBalloon With bln .Heading = "Select a Printer." .Labels(1).Text = "Network Printer" .Labels(2).Text = "Local Printer" .Labels(3).Text = "Local Color Printer" .BalloonType = msoBalloonTypeButtons .Mode = msoModeModeless .Callback = "ProcessPrinter" .Show End With End Sub Sub ProcessPrinter(bln As Balloon, lbtn As Long, _ lPriv As Long) Assistant.Animation = msoAnimationPrinting Select Case lbtn Case -1 ' Insert network printer-specific code. Case -2 ' Insert local printer-specific code. Case -3 ' Insert color printer-specific code. End Select bln.Close End Sub

Close close method close office assistant window close the active modeless balloon exit active balloon ofv terminate an active balloon

See also: