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

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

(Pete Cresswell)

RE:
-------------------------
For Each cmt In ActiveSheet.Comments
.Selection.TypeText cmt.Parent.Address _
& vbTab & cmt.Text
.Selection.TypeParagraph
Next
 
D

Debra Dalgleish

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top