Cell Comments

[Mike F.]

Is it possible to view the content of a group of cells in
another part of a worksheet in a cell comment.
I do not just want to input text but rather see the
content of a group of cells.
Thanks to anyone out there who can help, it's appreciated.
Mike

 

[Frank Kabel]

Hi
this would only possible with VBA. e.g. using the
worksheet_change event and creating the comment
programmatically

 

[Jason Morin]

You can click a cell and run this macro:

Sub Test()
Dim rngtext As String
Set rng = Range("A1:A4")
For Each cell In rng
rngtext = rngtext & " " & cell.Text
Next cell
ActiveCell.AddComment rngtext
End Sub

--
In this case a comment will be inserted with the contents
of A1:A4. To run the macro, press Alt+F11, Insert >
Module, and paste in the code. Then run it from XL.

HTH
Jason
Atlanta, GA

 

[Jason Morin]

You can also resize the comment box to fit the contents
using this line under "ActiveCell.AddComment rngtext":

ActiveCell.Comment.Shape.TextFrame.AutoSize = True

Jason