Array output and comment

[Torben Laursen]

Hi

I have a function that my user calls and it returns a array of values into
the cell's he has marked.

But is it possible to add a different comment to each cell every time the
function updates like when an input cell is changed?

Thanks Torben

 

[Dave Peterson]

I could use a function like this to update a comment in that cell with the
formula:

Option Explicit
Function myFunct(rng1 As Range, rng2 As Range) As Double
With Application.Caller
If .Comment Is Nothing Then
'do nothing
Else
.Comment.Delete
End If
.AddComment Text:="Hi there " & Format(Time, "hh:mm:ss")
End With
myFunct = rng1.Value + rng2.Value
End Function

Maybe it'll help you.