How to open a comment for user editing from VBA (XL 2000).
Posted on 2011-03-03
I am trying to create a Macro (in XL 2000) that will create a customized comment and open it for the user to modify. The first part is easy:
ActiveCell.AddComment ("Customized Text")
However opening the resulting comment seems to pose a problem. Neither the Comment object nor its associated Shape object appear to offer any appropriate methods. Attempting to use:
results in the error message:
Run-time error '-2147467259 (80004005)':
Method 'Select' of object 'Shape' failed
As I read the documentation, the command:
should do just what I want, but this seems totally ineffective. That is, nothing happens at all. Not even an error message. (The corresponding menu command can be invoked using SendKeys "%iE~", but of course SendKeys is inherently unreliable/risky and I won't use it in any "real" application.)
Can anyone suggest how I can use VBA to open a Comment for user editing?