ExcelBanter - Comment insert

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Comment insert (https://www.excelbanter.com/excel-worksheet-functions/195860-comment-insert.html)

THill

Comment insert

Is it possible to have a comment inserted into a cell using an if formula.
Something like if(a1, insert comment, 0)?

Bob Umlas, Excel MVP

Comment insert

=IF(A14,"This is your comment","")

"THILL" wrote:

Is it possible to have a comment inserted into a cell using an if formula.
Something like if(a1, insert comment, 0)?

THill

Comment insert

no i meant the insert comment function. i was wondering if it was possible to
have it pull up the comment window if a cell was true.

"Bob Umlas, Excel MVP" wrote:

=IF(A14,"This is your comment","")

"THILL" wrote:

Is it possible to have a comment inserted into a cell using an if formula.
Something like if(a1, insert comment, 0)?

Infinitogool

Comment insert

THILL escribió:
visit:
http://www.mvps.org/dmcritchie/excel/ccomment.htm

Regards,
Pedro J.

no i meant the insert comment function. i was wondering if it was possible to
have it pull up the comment window if a cell was true.

"Bob Umlas, Excel MVP" wrote:

=IF(A14,"This is your comment","")

"THILL" wrote:

Is it possible to have a comment inserted into a cell using an if formula.
Something like if(a1, insert comment, 0)?

All times are GMT +1. The time now is 05:39 AM.