Validation.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.

Syntax

expression.IMEMode

expression   A variable that represents a Validation object.

Remarks

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.

  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

See Also

• Validation Object
• Validation Object Members