I'm using the below code to run a macro that add comments to cells. Does
anyone know if there is anyway I can edit the code so that when the
comment box is generated it contains text from a specific cell within
the workbook? I would like to do it this way as the changes requently.


ActiveCell.AddComment
ActiveCell.Comment.Text Text:=""
ActiveCell.Comment.Visible = True

With ActiveCell.Comment.Shape.OLEFormat.Object
..Font.Name = "Arial"
..Font.Size = 20
..Font.Bold = True
..Width = 400
..Height = 300

End With


End Sub


C.






------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/