Adding Excel comments 1

[diarmaid]

Can anyone advise on how to convert this to VFP syntax

Range("P5").AddComment
Range("P5").Comment.Visible = False
Range("P5").Comment.Text Text:=" :" & Chr(10) & "This is a comment"

That is what an Excel macro produces in EXCEL to add comment text to a cell.

In VFP using the above .AddComment actually adds the comment to the Excel cell, I ignored the .Visible part, but I cant figure out the syntax for the last part, actually adding the text.

Any help appareciated ...

 

[bborissov]

Range("P5").Comment.Text(" :" + Chr(10) + "This is a  comment")

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.