Thread: Comments
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vlado Sveda Vlado Sveda is offline
external usenet poster
 
Posts: 50
Default 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??