Validation.IMEMode Property

Syntax

expression.IMEMode

expression A variable that represents a Validation object.

Remarks

Constant	Description
xlIMEModeAlpha	Half-width alphanumeric
xlIMEModeAlphaFull	Full-width alphanumeric
xlIMEModeDisable	Disable
xlIMEModeHiragana	Hiragana
xlIMEModeKatakana	Katakana
xlIMEModeKatakanaHalf	Katakana (half-width)
xlIMEModeNoControl	No control
xlIMEModeOff	Off (English mode)
xlIMEModeOn	On

Note that this property can be set only when Japanese language support has been installed and selected.

Example

This example sets the data input rule for cell E5.

Visual Basic for Applications

Visual Basic for Applications
`With Range("E5").Validation .Add Type:=xlValidateWholeNumber, _ AlertStyle:= xlValidAlertStop, _ Operator:=xlBetween, Formula1:="5", Formula2:="10" .InputTitle = " " .ErrorTitle = " " .InputMessage = "5 10 " .ErrorMessage = " 5 10 " .IMEMode = xlIMEModeAlpha End With`

With Range("E5").Validation .Add Type:=xlValidateWholeNumber, _ AlertStyle:= xlValidAlertStop, _ Operator:=xlBetween, Formula1:="5", Formula2:="10" .InputTitle = "   " .ErrorTitle = "   " .InputMessage = "5   10             " .ErrorMessage = "        5   10       " .IMEMode = xlIMEModeAlpha End With

IME IME mode imemode imemode property

Returns or sets the description of the Japanese input rules. Can be one of the XlIMEMode constants listed in the following table. Read/write Long.

See also: