This documentation is archived and is not being maintained.

Case Cell (Character Section)

Office 2007

Determines the case of a shape's text. All capital (uppercase) letters (1) and initial capital letters (2) do not change the appearance of text that was entered in all capital letters. The text must be entered in lowercase letters for these options to show an effect.

ValueDescriptionAutomation constant

0

Normal case

visCaseNormal

1

All capital (uppercase) letters

visCaseAllCaps

2

Initial capital letters only

visCaseInitialCaps

Remarks

To get a reference to the Case cell by name from another formula, or from a program using the CellsU property, use:

Cell name:

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

To get a reference to the Case 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:

visCharacterCase



Show: