2.2.3.16 insertCmt


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

<active>
 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$="";

Related X-Functions

insertArrow, insertGraph, insertImg

English | Deutsch | 日本語