Bopo2
11-07-2009, 06:42 PM
Hey guys
Well basically I'm creating cell comments by VBA via:
Worksheets("Data").Range("P11").AddComment ("woot")
However I can't find ANY method of editing the comment text via VBA, all I get are constant (pun not indended) errors. I'm really starting to dislike VBA in office packages, it seems every task that is plausible to me, is totally in-plausible to VBA, despite it being so trivial from a logical point on view.
Well basically I'm creating cell comments by VBA via:
Worksheets("Data").Range("P11").AddComment ("woot")
However I can't find ANY method of editing the comment text via VBA, all I get are constant (pun not indended) errors. I'm really starting to dislike VBA in office packages, it seems every task that is plausible to me, is totally in-plausible to VBA, despite it being so trivial from a logical point on view.