Export (0) Print
Expand All

Language-Specific Properties, Methods, and Functions

The Microsoft Office Excel Visual Basic for Applications (VBA) object model has language-specific elements for use with Asian and right-to-left languages.

The following table lists methods that have language-specific arguments. Methods that have new arguments or fewer arguments than in earlier versions of Excel are noted.

Method

Objects

Comments

Add

Phonetics

AddLabel

Shapes

AddTextbox

Shapes

AutoFormat

Range

CheckSpelling

Application, Chart, Range, Worksheet

Added SpellLang and removed IgnoreInitialAlefHamza and IgnoreFinalYaa

Find

Application, Range

Removed MatchControlCharacters, MatchDiacritics, MatchKashida, and MatchAlefHamza

GetPhonetic

Application

Replace

Range

Removed MatchControlCharacters, MatchDiacritics, MatchKashida, and MatchAlefHamza

SetPhonetic

Range

Sort

Range

Removed IgnoreControlCharacters, IgnoreDiacritics, and IgnoreKashida

SortSpecial

Range

Properties that return or set language-specific attributes are listed in the following table.

Property

Objects

AddIndent

Range, Style

AddressLocal

Range

Alignment

Phonetic, Phonetics, TextEffectFormat, TickLabels

CharacterType

Phonetic, Phonetics

ControlCharacters

Application

CursorMovement

Application

DefaultSheetDirection

Application

DisplayRightToLeft

Window, Worksheet

FileFormat

Workbook

HorizontalAlignment

AxisTitle, ChartTitle, DataLabel, DataLabels, DisplayUnitLabel, Range, Style, TextFrame

IMEMode

Validation

International

Application

Item

Phonetics

Length

Phonetics

Phonetic

Range

PhoneticCharacters

Characters

Phonetics

Range

ReadingOrder

AxisTitle, ChartTitle, DataLabel, DataLabels, DisplayUnitLabel, Range, Style, TextFrame, TickLabels

Start

Phonetics

VerticalAlignment

AxisTitle, ChartTitle, DataLabel, DataLabels, DisplayUnitLabels, Range, Style, TextFrame

The following are language-specific worksheet functions:

Show:
© 2014 Microsoft