ActiveX
To provide a cell note for a cell
- Set the Col and Row properties as appropriate.
-
Set the TextTip property to a value other than 0 (Off).
Note: This setting affects both text tips and cell notes. -
Set the CellNoteIndicator property as follows:
- If you want to display the cell note indicator and to have the TextTipFetch event occur, set the CellNoteIndicator property to 0 (ShowAndFireEvent).
- If you want to display the cell note indicator and to not have the TextTipFetch event occur, set the CellNoteIndicator property to 1 (ShowAndDoNotFireEvent).
- If you want to hide the cell note indicator and to have the TextTipFetch event occur, set the CellNoteIndicator property to 2 (DoNotShowAndFireEvent).
- If you want to hide the cell note indicator and to not have the TextTipFetch event occur, set the CellNoteIndicator property to 3 (DoNotShowAndDoNotFireEvent).
- At run time, specify the text to display in the cell note by setting the CellNote property.
-
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.