Thread: annotation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default annotation

On Mar 8, 7:28 pm, "jimmy" wrote:
How to write a annotation to a cell explain what the cell means?
Thanks


Public Sub test()
Range("A1").AddComment Text:="This is annotation"
End Sub

adds a comment to the A1 cell of the active sheet
regards
Paul