ActiveX
To specify header text
At run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
-
To provide custom text for the column headers,
- If you want to provide custom text for a column header,
-
If you want to provide custom text for a range of column headers,
- 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.
- Set the BlockMode property to True.
- Select a column range with the Col and Col2 properties.
- Specify the text with the Text property.
- Set the BlockMode property back to False.
-
To provide custom text for the row headers,
- If you want to provide custom text for a row header,
-
If you want to provide custom text for a range of row headers,
- 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.
- Set the BlockMode property to True.
- Select a column range with the Row and Row2 properties.
- Specify the text with the Text property.
- Set the BlockMode property back to False.