Edit

Share via

Validation.IMEMode property (Excel)

  • Article

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

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.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.