Microsoft Office Tutorials and References
In Depth Information
Figure 19-26. The Input Message tab of the Data Validation dialog
This dialog corresponds to setting:
Type:=xlValidateWholeNumber
Operator:=xlBetween
Formula1:="5"
Formula2:="10"
IgnoreBlank = True
You can learn more about the Type constants by clicking on the ? button in the Data Validation
dialog and then clicking on the Allow drop-down list box. Note that the other controls on the tab
in Figure 19-25 will change depending upon the value selected in the Allow drop-down box.
The Input Message tab is shown in Figure 19-26 . The values in this dialog correspond to
properties of the Validation object. In particular, we have:
ShowInput = True
InputTitle = "Input:"
InputMessage = "Input a number"
Figure 19-26. The Input Message tab of the Data Validation dialog
 
Search JabSto ::




Custom Search