Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thomas,
try this: Read the comment from cell A2 by: MyComment = split(range("a2").Comment.Text,":")(1) Stick it in cell A1: Range("a1") = Mycomment The split statement will take off the Username that comes with the comment. Ko Vijn "Thomas Eggenschwiler" schreef in bericht om... How can I create a reference (in cell A1) to comments I inserted in cell A2? Or asking the question in a different way: Can I display the comments from cell A2 in cell A1 by referring to the comments of cell A2 (not the value in cell A2)? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
Printing Comments & Cell Reference | Excel Discussion (Misc queries) | |||
How do I reference the comments of a cell? | Excel Discussion (Misc queries) | |||
Can I reference comments by Cell Name? | Excel Discussion (Misc queries) | |||
how to print reference label name in excel for comments? | New Users to Excel |