ActiveX

To limit user entry in an edit cell

At run time,

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Set the Col, Col2, Row, and Row2 properties as appropriate.
3. If you are selecting a block of cells, set the BlockMode property to True.
4. Set the CellType property to 1 (Edit).
5. Provide a character set that specifies what the user can type into the cell by setting the TypeEditCharSet property.
6. Specify the maximum number of characters allowed in the cell using the TypeMaxEditLen property.
7. Allow users to type text in multiple lines by setting the TypeEditMultiLine property to True.
8. If you selected a block of cells, set the BlockMode property back to False.