ActiveX

To create and set up a date 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 0 (Date).
5. Set the TypeDateMax and TypeDateMin properties to specify the maximum and minimum date values for the cell.
   When providing the maximum and minimum date values, use the format "MMDDYYYY", where "MM" stands for two-digit month, "DD" stands for two-digit day, and "YYYY" stands for four-digit year.
6. Specify how the century is calculated by setting the TwoDigitYearMax property to the calculation date.
   Spread calculates the minimum year by subtracting 99 years from the calculation date.
7. Specify the horizontal and vertical alignment of the text by setting the TypeHAlign and TypeVAlign properties.
8. Specify the text orientation of the data in the cell by setting the TypeTextOrient property.
9. If you selected a block of cells, set the BlockMode property back to False.