Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Office Assistant VBA | Excel Discussion (Misc queries) | |||
How do you get an Assistant? | New Users to Excel | |||
Avery Assistant add-in | Excel Discussion (Misc queries) | |||
Office Assistant ... | Excel Programming | |||
Office Assistant | Excel Discussion (Misc queries) |