Comments: dynamic content

Question

Excel 2010 on Window7.

what are the possibilities to put dynamic contents in a comment?  Could we for example put a formula that refers to a cell in the spreadsheet?

Many thanks in anticipation.

Answer 1

Excel 2010 on Window7.

 

what are the possibilities to put dynamic contents in a comment?  Could we for example put a formula that refers to a cell in the spreadsheet?

 

Many thanks in anticipation.

Hi,

No you can't do that but you could use VB code to display dynamic content.  This assumes we already have a comment in cell A1. Right click the worksheet tab, view code and paste the code below in. Now if you change the cell A1, whatever you put in there is also added as the comment text,

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub

If Target.Address = "$A$1" Then

    Application.EnableEvents = False

    Range("A1").Comment.Text Text:=Range("A1").Text

    Application.EnableEvents = True

    End If

End Sub

Answer 2

Thanks Mike.

Under the circumstances that there is no function/formula for dynamic contents, the next best choice is the VB code.

Thanks for providing already a template.  It would work well, I will adapt it to my needs.