ExcelGetCellComment

Structure

ExcelGetCellComment(iRow,iCol)

Type

Function

Description

This function returns the comment in the indicated cell of the current sheet as a string.

Parameters: 2

iRow = The row of the cell to get the comment from. 1 is the top row.

iCol = The columns of the cell to get the comment from. 1 corresponds to column A

Example

Try

ExcelNewFile(3,"v2003")

ExcelGetSheetByIndex(1)

ShowMessage(ExcelGetCellComment(1,1)) 'Returns ""

ExcelSetCellComment(1,1,"This is a comment")

ShowMessage(ExcelGetCellComment(1,1)) 'Returns "This is a comment"

Except

ShowMessage(LastExceptionMessage)

End Try