Cell Type Settings Remembered

When you are working with cell type settings in the ActiveX controls, you must be aware that the controls remember cell type settings. For example, if you create a date cell and set the TypeDateSeparator property for that cell, subsequent date cells you create will have the same TypeDateSeparator setting.

Some cell type property settings are specific to a cell type and so are not changed by the setting of other cell types. For example, the vertical alignment set using the TypeVAlign property is not unique to edit cells. Therefore, if you create an edit cell and set the TypeVAlign property for the cell, then set that value using a different cell type for other cells, subsequent edit cells you create will not use the alignment you specified for the first cell. You may have to set the property for each cell you create since the vertical alignment may be different for each cell type.

Keep this behavior in mind when setting cell types. There is a note in each property topic in the ActiveX Reference for properties that are unique to each cell type.