InputType Property

Applies To

DrawingObjects Collection, EditBox Object, EditBoxes Collection.

Description

Returns or sets what type of input validation is applied to the contents of an edit box (one of xlFormula, xlInteger, xlNumber, xlReference, or xlText). Read-write.

Example

This example sets edit box one on Dialog1 to require an integer.


DialogSheets("Dialog1").EditBoxes(1).InputType = xlInteger