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??
|