Cell Pop-Up Notes: Any way to extract them programatically?

  • Thread starter Thread starter PeteCresswell
  • Start date Start date
P

PeteCresswell

I've got a sheet that lists various mutual funds and their returns in
it's columns.

However, somebody has put the inception date of each fund in a pop-up
note attached to the fund column. i.e. the cell with fund's name has
a little red triangle in it's upper right corner and when the cursor
hovers over it, a yellow note pops up.

I'm going at this sheet via a VBA Excel.Application object and would
like to extract this data.

My guess would be that each cell can have a collection of
something-or-other that points to the pop-up notes.

Anybody know for sure?
 
RE:
-------------------------
For Each cmt In ActiveSheet.Comments
.Selection.TypeText cmt.Parent.Address _
& vbTab & cmt.Text
.Selection.TypeParagraph
Next
 
You're welcome. Thanks for letting me know.

(Pete Cresswell) said:
RE:
-------------------------
For Each cmt In ActiveSheet.Comments
.Selection.TypeText cmt.Parent.Address _
& vbTab & cmt.Text
.Selection.TypeParagraph
Next
 
Back
Top