Expand Minimize
This topic has not yet been rated - Rate this topic

Case cell (Character section)

Office XP

Case cell (Character section)

See also         http://msdn.microsoft.com/en-us/library/aa200465(v=office.10) Section         Rows

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.

Value

Description

Automation constant

0

Normal case

visCaseNormal

1

All capital (uppercase) letters

visCaseAllCaps

2

Initial capital letters only

visCaseInitialCaps

Remarks

To reference the Case cell by name from another formula, or from a program using the http://msdn.microsoft.com/en-us/library/aa141912(v=office.10) Cells property, use:

Cell name:

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

To reference the Case cell by index from a program, use the http://msdn.microsoft.com/en-us/library/aa141916(v=office.10) CellsSRC property with the following arguments:

Section index:

visSectionCharacter

Row index:

visRowCharacter + i
where i = 0, 1, 2, …

Cell index:

visCharacterCase

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.