Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Comments Referencing Excel Formula
I know that you can have TextBox objects in Excel which have
a .DrawingObject.Formula property that you can set programmatically (or in the GUI) so that whenever you calculate the sheet, if the underlying cell changes the textbox's text will also change. Is this possible to do with Excel Comments? I have already tried to Comment.Shape.DrawingObject.Formula, but it errors out, saying that you cannot access that property. Is there any way to make the text of a comment dynamically refer to the contents of a cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing Comments in Excel 2003 | Excel Discussion (Misc queries) | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
Excel-comments entered by users disappear in a shared excel-sheet | Excel Worksheet Functions | |||
COM Addin for Excel: Despite referencing the Excel Object Library no objects availabl | Excel Programming |