ActiveX

To provide a cell note for a cell

1. Set the Col and Row properties as appropriate.
2. Set the TextTip property to a value other than 0 (Off).

   Note: This setting affects both text tips and cell notes.

3. Set the CellNoteIndicator property as follows:
   1. If you want to display the cell note indicator and to have the TextTipFetch event occur, set the CellNoteIndicator property to 0 (ShowAndFireEvent).
   2. If you want to display the cell note indicator and to not have the TextTipFetch event occur, set the CellNoteIndicator property to 1 (ShowAndDoNotFireEvent).
   3. If you want to hide the cell note indicator and to have the TextTipFetch event occur, set the CellNoteIndicator property to 2 (DoNotShowAndFireEvent).
   4. If you want to hide the cell note indicator and to not have the TextTipFetch event occur, set the CellNoteIndicator property to 3 (DoNotShowAndDoNotFireEvent).
4. At run time, specify the text to display in the cell note by setting the CellNote property.
5. If you want to customize the cell note appearance, call the SetTextTipAppearance method.

   Note: The SetTextTipAppearance method customizes the appearance of both text tips and cell notes. However, you can use the SetTextTipAppearance method in the IsFetchCellNote method in the TextTipFetch event to specify a different appearance for cell notes and text tips.