View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default popup balloon (not msgbox)

The callouts (ballons) are on the drawing toolbar (View - Toolbars - Drawing)
under Autoshape - Callouts.

Yo can add them programmably as follows:

Set NewCallout = ActiveSheet.Shapes _
.AddShape(msoShapeRoundedRectangularCallout, _
243#, 217.5, 72#, 48#)

"Albert" wrote:

Hello!

Is it possible to create through VBA a popup balloon, like the ones that
tell you have unused icons?

(like this one
http://lifehacker.com/350132/disable...-icons-balloon)

It would be VERY cool!

Thanks,
Albert C