ActiveX

To specify header text

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. To provide custom text for the column headers,
   1. If you want to provide custom text for a column header,
      1. Set the Row property to 0, or if you are displaying multiple column headers, set the Row property to SpreadHeader + n, where n is the number of rows from the top header.
      2. Specify the column with the Col property.
      3. Specify the text with the Text property.
   2. If you want to provide custom text for a range of column headers,
      1. Set the Row property to 0, or if you are displaying multiple column headers, set the Row property to SpreadHeader + n, where n is the number of rows from the top header.
      2. Set the BlockMode property to True.
      3. Select a column range with the Col and Col2 properties.
      4. Specify the text with the Text property.
      5. Set the BlockMode property back to False.
3. To provide custom text for the row headers,
   1. If you want to provide custom text for a row header,
      1. Set the Col property to 0, or if you are displaying multiple row headers, set the Col property to SpreadHeader + n, where n is the number of columns from the left header.
      2. Specify the row with the Row property.
      3. Specify the text with the Text property.
   2. If you want to provide custom text for a range of row headers,
      1. Set the Col property to 0, or if you are displaying multiple row headers, set the Col property to SpreadHeader + n, where n is the number of columns from the left header.
      2. Set the BlockMode property to True.
      3. Select a column range with the Row and Row2 properties.
      4. Specify the text with the Text property.
      5. Set the BlockMode property back to False.