Thread: Comment
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Comment

Sendkeys "types" those characters

Select a cell with a comment in it.
hit alt-i (insert from the worksheet menubar)
(alt is represented by %)
e (accellerator key for Edit Comment (notice the underline)
~ (sends an enter key)



Robbyn wrote:

Hi Debra. I checked out your code for comments and am wondering what 'SendKeys "%ie~" does?

Robbyn


--

Dave Peterson