Style cell (Character section)

       Rows

Shows the character formatting applied to a range of text in the shape's text block.

Style	Value	Automation constant
Bold	&H1	visBold
Italic	&H2	visItalic
Underline	&H4	visUnderLine
Small caps	&H8	visSmallCaps

Remarks

The Style cell contains formatting information applied to a sub-range of a shape's text if the Characters section contains multiple rows. Otherwise, it contains formatting information for all of the shape's text.

The value represents a binary number in which each bit indicates a character style. For example, a value of 3 represents text formatted in both italic and bold. If the value of Style is 0, the text is plain, or unformatted. You can test for a particular format using Boolean BIT* functions. See your programming documentation for details about these functions.

To reference the Style cell by name from another formula, or from a program using the Cells property, use:

Cell name:

Char.Style[i] where i = <1>, 2, 3…

To reference the Style cell by index from a program, use the CellsSRC property with the following arguments:

Section index:	visSectionCharacter
Row index:	visRowCharacter + i where i = 0, 1, 2…
Cell index:	visCharacterStyle

Example

Suppose the Color cell in the first row of a shape's Character section is set to this formula:

= IF(BITAND(Char.Style,1)=1,4,3)

Then if the first character of the shape's text is bold, the text covered by the first Character properties row will be blue (4); otherwise it will be green (3). This example assumes default colors are in effect.

The following is an example of setting the Style cell in a program. The first statement references the Style cell by name, and the second statement references the Style cell by index. Both statements apply italics to the text covered by the second row of a shape's Character section.

shpObj.Cells("Char.Style[2]").ResultIU = visItalic
shpObj.CellsSRC(visSectionCharacter, visRowCharacter + 1, _
     visCharacterStyle).ResultIU = visItalic