ExcelBanter - Inserting Comments

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Inserting Comments (https://www.excelbanter.com/excel-discussion-misc-queries/246800-inserting-comments.html)

Greggo G[_2_]

Inserting Comments

Hi

Not sure if I have posted this question before.

Is it possible to have a comment "automatically" created in a cell if the
contents of that cell meets a certain set of criteria?

Thanks in advance

Jacob Skaria

Inserting Comments

Yes; using a macro and making use of Worksheet_Change event.

If this post helps click Yes
---------------
Jacob Skaria

"Greggo G" wrote:

Hi

Not sure if I have posted this question before.

Is it possible to have a comment "automatically" created in a cell if the
contents of that cell meets a certain set of criteria?

Thanks in advance

All times are GMT +1. The time now is 10:12 AM.