## COMMENT BOXES WITH CHANGIGN DATA ##

[rudling]

me again..! i hope you are as quick and helpful as last time!

I have a set of ranges i.e Green max = 3, green min = 0, red max = 10, red min = 3

I want to put a comment box on my spread sheet that shows these ranges, but I want the comment box to update if I change the ranges on the spread sheet...

any help is so appreciated

 

[Cloverken]

you need some VBA code. This would work. If you change the Values in cells E1:E4 the comment values would change in cell A1.

You can download an example workbook at:

http://www.squish.com/Cloverleaf/Comment.xls

To view the code on the example worksheet you can press Alt+F11

Here is the VBA code Below

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Set rng = Sheets("Comments").Range("A1")
rng.ClearComments
rng.AddComment
rng.Comment.Visible = True
rng.Comment.Text Text:="Green Max = " & Range("E1").Value _
& Chr(10) & "Green Min = " & Range("E2").Value & Chr(10) & "Red Max = " & _
Range("E3").Value & Chr(10) & "Red Min = " & Range("E4").Value
End Sub

 

[rudling]

you my friend, are a legend