Skip to main content

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​

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