expression.IMEMode
expression Required. An expression that returns one of the objects in the Applies To list.
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 |
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