2.2.3.16 insertCmt
Contents
Menu Information
Insert Note
Brief Information
Add a Notes to a worksheet cell
Additional Information
Minimum Origin Version Required: 2022
X-Function not designed for Auto GetN Dialog.
Command Line Usage
1. insertcmt str:="This is a peak";
2. insertcmt str:="New Data" orng:=[Book1]Sheet1!col(1)[2];
Variables
| Display Name |
Variable Name |
I/O and Type |
Default Value |
Description |
|---|---|---|---|---|
| Default Text | str |
Input string |
|
Enter the notes content |
| Cell | orng |
Output Range |
|
Specifies the worksheet cell where the note will be inserted.
See the syntax here. |
Description
This X-Function is used to add a note to a selected worksheet cell. You can also
- click on a worksheet cell and select Insert Note from mini toolbar, or,
- right click on a worksheet cell and select Insert Notes context menu.
After running insertcmt to add a note to a worksheet cell, you can select the cell again and further customize or remove the note.
- To directly edit the comment in the note, use
s.Notes$
- To open the note in a separated Notes window, use
s.ed = 2;
- To remove the note, use
s.Notes$="";
- To directly edit the comment in the note, use