ActiveX

To display customized column headers

1. Follow the steps listed for Connecting to a Database Using Default Settings to bind the sheet to a database.
2. Set the DAutoHeadings property to False.
3. At run time, specify the column header in which to display the custom text by setting the Col and Row properties.
4. At run time, supply the text for the column header using the Text property.