ActiveX

To create 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. Specify the case of the characters provided to the cell by setting the TypeEditCharCase property.
6. Specify the text alignment using the TypeHAlign and TypeVAlign properties.
7. Specify the text orientation of the data in the cell by setting the TypeTextOrient property.
8. Set up the cell to appear as a password entry field by setting the TypeEditPassword property to True.
9. If you selected a block of cells, set the BlockMode property back to False.