ActiveX

To format 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. Specify the date format by setting the TypeDateFormat property.
6. Display the year in century format (four-digits), by setting the TypeDateCentury property to True.
7. Specify the character that separates the day, month, and year by setting the TypeDateSeparator property.
8. If you want to display a spin button, set the TypeSpin property to True.
9. If you selected a block of cells, set the BlockMode property back to False.