Comments
 

Is it possible to insert a Comment into a Cell like :

=Sheet2!B2

and Display the value of that refernce in the comments box??

Comments
 

Hi Corey,

use something like this:

- insert comment:
MyWorkbook.MyWorksheet.Cells(MyRow, MyColumn).AddComment

- write comment content
MyWorkbook.MyWorksheet.Cells(MyRow, MyColumn).Comment.Text Text:=
"MyText"

- read comment content
MyString = MyWorkbook.MyWorksheet.Cells(MyRow, MyColumn).Comment.Text

Vlado


"Corey" wrote:

Is it possible to insert a Comment into a Cell like :

=Sheet2!B2

and Display the value of that refernce in the comments box??