Thank you again. This is very valuable information. As you can see, I'm
really new at this. I'm finding the help text not well organized for my
purposes. I hope you all will tolerate my questions.


"Debra Dalgleish" wrote in message
...
The % represents the Alt key, so Alt+i opens the Insert menu
On the Insert menu, the e in Edit Comment is underlined, so that command
is selected when the e is sent.

Christopher Weaver wrote:
Thank you, that's exactly what I was looking for.

BTW, what does "%ie~" refer to in the SendKeys?



"Debra Dalgleish" wrote in message
...

There's some sample code for inserting or editing comments he

http://www.contextures.com/xlcomments03.html#Plain

Christopher Weaver wrote:

I would like the user to be taken to a new comment, or the existing
one,

of

the currently selected cell. I can get a new comment inserted

With Selection
.AddComment
.Comment.Visible = False
.Comment.Text Text:=""

End With


but I can't get the cursor to end up inside the comment, awaiting the

user's

input.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html