Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test a cell for a comment presence from within a macro form 2007
I would like to completely control cell comments from a macro form. I am
unable to determine if a cell does not have a comment or does have one. How do you relate the comment of each cell in a row of cells to its comment object. Comment index numbers do not seem to carry any relationship with them outside the object. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test a cell for a comment presence from within a macro form 2007
dim cell as Range
dim cmt as Comment '' relate comment to cell For each cell in Range("A1:J1") If not cell.Comment Is nothing then ' it has a comment Set cmt = cell.Comment ' if want to do more with the comment debug.? cell.Address(),0) debug.? cmt.Text end if next relate cell to comment For each cmt in Activesheet.comments debug.? cmt.parent.Address(),0) debug.? cmt.Text Next Regards Peter T "Fritz" wrote in message ... I would like to completely control cell comments from a macro form. I am unable to determine if a cell does not have a comment or does have one. How do you relate the comment of each cell in a row of cells to its comment object. Comment index numbers do not seem to carry any relationship with them outside the object. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add comment in cell using excel 2007 | Excel Worksheet Functions | |||
How can I test a range of cells for the presence of a border? | Excel Worksheet Functions | |||
How to test Excel 2003 & 2007 macro security level | Excel Programming | |||
Test for presence of chart on active sheet | Excel Programming | |||
Need to test for file presence | Excel Programming |