Hmmm...Help in XLv.X brings up the Text method as the 6th item.

You could also check the Comment object in Help and find that is has a
Text method associated with it.

Or you could look at the Comment object in the Object Browser to find
the same thing.

In article ,
"Neil Garrard" wrote:

Thanks JE and Jake.

I guess the question becomes, how do you find about about this? I look up
text object in the various help files of VBA and found no reference to using
.text with comments to return the text. I guess it looks like you have to
try things that would possibly work!!