|
|
|
|
|
SpreadsheetListComment (Function) In french: TableurListeCommentaire Lists all the comments on the current worksheet of a Spreadsheet control.
FOR EACH Comment OF SpreadsheetListComment(PSHEET_MySpreadsheet)
Comment..Visible = True
END
FOR EACH Comment OF SpreadsheetListComment(PSHEET_MySpreadsheet)
Comment..Text = ""
END
MyCommentArray is array of xlsComment
MyCommentArray= SpreadsheetListComment(PSHEET_MySpreadsheet)
FOR EACH comment OF MyCommentArray
Trace(comment..Text)
END
Syntax
<Result> = SpreadsheetListComment(<Spreadsheet control>)
<Result>: Array Array containing the different comments with their characteristics. This array contains xlsComment variables. <Spreadsheet control>: Control name Name of the Spreadsheet control to be used. Remarks - Modifying a comment in the array also modifies it in the Spreadsheet control.
- Adding or deleting a comment in the array has no effect on the comments in the Spreadsheet control.
- If there is no comment in the worksheet, the array is empty.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|