View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shaun
 
Posts: n/a
Default Linking Comment to Cell

Thank you very much, but I think this may be more technical than I am.
UDF?
What do I do with this code?

Shaun

"Gary''s Student" wrote:

Try this UDF:

Function copycomment(r As Range)
Application.Volatile
Dim whereami As Range
Set whereami = Application.Caller
If whereami.Comment Is Nothing Then
Else
whereami.Comment.Delete
End If
whereami.AddComment Text:=r.Value
copycomment = ""
End Function
--
Gary''s Student


"Shaun" wrote:

I need to link information found in other sheets of my workbook to comment
boxes on my first sheet. Can this be done, and if so, how?? Any help is
much appreciated, thanks.

Shaun