|Posted by davesexcel on March 29, 2012 at 7:50 PM|
I want to add a comment to H1 and place what is in Cell A1 to be in the comment.
You can use VBA to add a comment and have what is in A1 in the comment box.
Dim A1 As Range
Set A1 = Range("A1")
.Comment.Visible = False
.Comment.Shape.TextFrame.AutoSize = True