#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
problems with inserting comments Derrick Excel Discussion (Misc queries) 1 August 19th 09 04:28 PM
Inserting comments milt Excel Worksheet Functions 3 March 28th 08 12:22 AM
Inserting Comments en mass Heather Excel Discussion (Misc queries) 2 November 2nd 07 07:34 PM
inserting comments ? sunrosejenn Excel Discussion (Misc queries) 5 March 7th 06 02:44 PM
Inserting comments on graphs Christopher Anderson Excel Discussion (Misc queries) 3 December 20th 04 09:18 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"