Programatically add "mouse over" comments in Excel

[dgillz]

Excel 2003. Does anyone know what cell property is used to add mouse over comments in Excel?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[PHV]

Have a look at the AddComment method and the Comment property:

With yourCell
  .AddComment
  With .Comment
    .Visible = False
    .Text Text:="your comment"
  End With
End With

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886