copy data into comments?

[Richard Miller]

How can you copy data from a cell to the comment of another cell?

 

[Ron de Bruin]

I don't think you can do this in a comment, but I good be wrong(I hope)

All you want to know about Comments you can find here
http://www.contextures.com/xlcomments01.html

 

[Ron de Bruin]

Hi Jason

I never know that, but I never use them<g>

 

[Dana DeLouis]

This is just another general idea...

Sub Demo()
' Data in B1 to Comment in A1

'If no data in B1, then exit
If [B1].Value = vbNullString Then Exit Sub

If [A1].Comment Is Nothing Then
' If no comment, then 'Add' a comment
[A1].AddComment [B1].Value
Else
'else change existing comment
[A1].Comment.Text [B1].Value
End If

'AutoSize comment if desired
[A1].Comment.Shape.TextFrame.AutoSize = True
End Sub