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";

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Default Text str

Input

string

Enter the notes content

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