ActiveX

To set the font

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.
   For more information about setting the Col and Row properties, see Using Column and Row Properties.
3. If you are selecting a block of cells, set the BlockMode property to True.
4. Set the appropriate font properties (Font or FontName, FontSize, FontBold, FontItalic, FontStrikethru, and FontUnderline).
5. If you selected a block of cells, set the BlockMode property back to False.