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