#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Comment insert

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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 320
Default 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)?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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)?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 52
Default 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)?

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
insert comment Matsd Charts and Charting in Excel 4 March 24th 07 10:58 PM
macro to insert a comment driller Excel Worksheet Functions 0 February 8th 07 10:22 PM
Protection will not allow me to insert a comment Wising Up Girls Excel Worksheet Functions 1 April 10th 06 08:43 PM
how do I insert image in a comment? t23augusto Excel Discussion (Misc queries) 1 July 31st 05 12:30 AM
How do I insert a comment when the Insert:Comment menu is greyed? none Excel Discussion (Misc queries) 0 May 19th 05 12:36 AM


All times are GMT +1. The time now is 06:57 PM.

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"