ActiveX
To create a PIC 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 4 (PIC).
-
Create the mask by providing the mask characters using the TypePicMask property.
Use the following characters to specify what type of data the user can type into the mask:
Mask Character Characters Allowed X Any ASCII character 9 0–9, decimal A A–Z, a–z
plus any alphabetic character from larger character sets such as ANSI or UnicodeN A–Z, a–z, 0–9, decimal U A–Z L a–z H (Hexadecimal) 0–9, a–f, A–F - Specify the text to display in an empty mask using the TypePicDefaultText property.
- Specify the horizontal and vertical text alignment in the cell by setting the TypeHAlign and TypeVAlign properties.
- Specify the text orientation of the data in the cell by setting the TypeTextOrient property.
- If you selected a block of cells, set the BlockMode property back to False.