I have tried in some other work a code similar to the following code in vba
Range("d2") = Range("a1").Comment.Text
but I am not aware whether it can be linked. perhaps a event code with
sheet_change can be attempted.
MarkM wrote in message
...
Is it possible to have comments for cells, appear in a seperate cells or
worksheet as data as they are added like link function ?
|