Thanks Mike - excellent.


"Mike H" wrote in message
...
Hi,

You don't give too much details but this enters a comment in C1 comprising
the Text in A1 & A2. Right click your sheet tab, view code and paste this
in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub
If Not Intersect(Target, Range("A1:A2")) Is Nothing Then
Application.EnableEvents = False
With Range("C1")
.ClearComments
.AddComment
.Comment.Text Range("A1").Value & Range("A2").Value
End With
Application.EnableEvents = True
End If
End Sub

Mike

"Steve Jones" wrote:

Hi

Is it possible to have for example the contents of cell A1 & A2 in the
comments box?

Therefore changing the comment as the cells change.

I have tried looking on Contextures site.

Thanks very much

Steve