Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Assistant NewBallon formatting


Hi, this is what I got from the Help files:

Under the help title
TEXT PROPERT
For the Balloon, BalloonLabel, and BalloonCheckbox objects, you ca
specify that a particular graphic be displayed by using the followin
syntax: {type location sizing_factor}, where type is bmp (bitmap) o
wmf (Windows metafile); location is the resource ID or the path an
file name; and sizing_factor denotes the width of the .wmf fil
(sizing_factor is omitted for .bmp files).

The Balloon object also supports underlined text and text that has on
of the 16 system palette colors applied to it. To display underline
text, use the syntax {ul} or {ul 1}; use {ul 0} to turn underlinin
off. To change the color of text, precede the text string with th
character sequence {cf number}, where number is one of the system colo
numbers listed in the following table.

System color number Color
0 Black
1 Dark red
2 Dark green
3 Dark yellow
4 Dark blue
5 Dark magenta
6 Dark cyan
7 Light gray
248 Medium gray
249 Red
250 Green
251 Yellow
252 Blue
253 Magenta
254 Cyan
255 White

If you specify a number other than one of the preceding system colo
numbers, the text in the Office Assistant balloon is black.

Under
MAKING RUN-TIME MODIFICATIONS TO BALLOON
After you create a balloon for the Office Assistant, you can customiz
it by adding bitmaps, icons, or Windows metafiles to the balloon'
heading or text. You can add controls such as check boxes or buttons t
your balloon so that you can respond to your user when he or she click
an item in the balloon. You can also use text attributes such as colo
and underlining to emphasize text elements in a balloon.

-ADDING ICONS AND BITMAPS TO BALLOONS
To add an icon, assign an MsoIconType constant to the Icon property o
the Balloon object. To add a bitmap or a Windows metafile to the tex
in an Office Assistant balloon, specify the type, the location, and th
sizing factor (if applicable) when you set the Text property of
heading, text, check box, or label. The following example inserts
Windows bitmap file into the text of a balloon.

myBmp = "{bmp c:\Windows\circles.gif}"
myText1 = "This is before the picture, "
myText2 = " and this is after the picture"
Set bln = Assistant.NewBalloon
With bln
.Heading = "Instructions for Choosing a Bitmap."
.Text = myText1 & myBmp & myText2
.Show
End With

This example creates a new Office Assistant balloon that contains
Windows metafile.

With Assistant.NewBalloon
.Heading = "Underlined {ul 1}Heading{ul 0}"
.Text ="{WMF ""C:\Favorites\MyPicture.WMF""}"
.Show
End With

-ADDING COLOR AND UNDERLINING TO TEXT IN BALLOONS
There are two attributes you can add to text in a balloon: color an
underlining. There are 16 supported system colors you can use t
emphasize text with color. You also can change the appearance of tex
in a balloon by underlining the text. Text attributes are embedded i
the text of the balloon and are surrounded by braces in the code. Th
following example creates a new Office Assistant balloon that contain
underlined heading text, red text, and blue text that is als
underlined.

With Assistant.NewBalloon
.Heading = "Underlined {ul 1}Heading{ul 0}"
.Text = "Some {cf 249}Red{cf 0} text and some " & _
"underlined {cf 252}{ul 1}Blue{ul 0}{cf 0} text."
.Show
End With

HT

--
AH·
-----------------------------------------------------------------------
AH·C's Profile: http://www.excelforum.com/member.php...fo&userid=2910
View this thread: http://www.excelforum.com/showthread.php?threadid=36423

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Office Assistant VBA Mojo Excel Discussion (Misc queries) 1 July 20th 09 09:53 PM
How do you get an Assistant? Frogger New Users to Excel 2 September 8th 07 12:05 PM
Avery Assistant add-in br549 Excel Discussion (Misc queries) 3 February 23rd 07 03:14 PM
Office Assistant ... SIGE Excel Programming 1 April 27th 05 06:42 PM
Office Assistant Sunflower Excel Discussion (Misc queries) 0 March 30th 05 06:51 AM


All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"