popup balloon (not msgbox)

J

Joel

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#)
 
A

Albert

Hi Joel,
Thanks for your reply.
I actually wanted one of those popups appearing on the taskbar, not within
Excel.
 
J

Joel

The callouts are a picture and should be able to be copied where evey you
need them. You might have to put them on your worksheet then right click and
saveas picture. Then inport the picture into your task bar.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top