Dynamic comments
 

Comments is a nice way to give information to users,unfourtunately I´m not
able to make dynamic comments.

Example:
I show sales in sheet 1 cell A1 (for instance 100)
Sales is populated from the sum sheet 2 A1=Europe 50 and A2 sheet 2 =USA 50

I want a comment in sheet 1 cell A1 displaying Europe 50, USA 50

If I change sheet 2 then sheet 1 cell A1 and its comments are updated.

Thanks for you help

Dynamic comments
 

A modification of this to suit should do it. You will need to know the
comment number found by right click lower right corner of the comment.

Right click the sheet tabview codecopy paste thismodify to suitSAVE. Now
when you change cell d5 to 5 the comment will show
Europe=5,USA=whatever is in cell d6

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$5" Then
Comments(1).Text "Europe= " & Target & ", USA=" & Range("d6")
End If
End Sub

--
Don Guillett
SalesAid Software

"Mariano" wrote in message
...
Comments is a nice way to give information to users,unfourtunately I´m not
able to make dynamic comments.

Example:
I show sales in sheet 1 cell A1 (for instance 100)
Sales is populated from the sum sheet 2 A1=Europe 50 and A2 sheet 2 =USA
50

I want a comment in sheet 1 cell A1 displaying Europe 50, USA 50

If I change sheet 2 then sheet 1 cell A1 and its comments are updated.

Thanks for you help