| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| ? about COMMENTS | Excel Worksheet Functions | |||
| Comments box | Excel Worksheet Functions | |||
| comments' pos | Excel Programming | |||
Linear Mode
