<div>
Edited text of question<br />

</div>


<div>
ecj1:<br />
<br />
For some reason sending Enter as {ENTER} does not work in this case. Use:<br />
<br />
Application.SendKeys &quot;%IE~&quot;<br />
<br />
The ~ is recognized as the ENTER key and does work.<br />

</div>


ecj1:

For some reason sending Enter as {ENTER} does not work in this case. Use:

Application.SendKeys "%IE~"

The ~ is recognized as the ENTER key and does work.


<div>
jgv,<br />
<br />
many thanks for you help.<br />
<br />
ecj1<br />

</div>


<div>
<div class="content wysiwyg-content">
I am currently automating the edit comment procedure within Excel 97 using VB. &nbsp;I am using the SendKey command to enter text into a comment field:<br />
Application.SendKeys (&quot;%IE&quot;)<br />
This works successfully but the menu remains active on the window and requires a &quot;return&quot; to disappear and activate the comments window. &nbsp;I have tried using variations on the following:<br />
Application.SendKeys (&quot;%IE {ENTER}&quot;) <br />
to try and resolve this, all to no avail.<br />
<br />
Best regards,<br />
<br />
Rob.
</div>
</div>


I am currently automating the edit comment procedure within Excel 97 using VB.  I am using the SendKey command to enter text into a comment field:
Application.SendKeys ("%IE")
This works successfully but the menu remains active on the window and requires a "return" to disappear and activate the comments window.  I have tried using variations on the following:
Application.SendKeys ("%IE {ENTER}") 
to try and resolve this, all to no avail.

Best regards,

Rob.

VB SendKey Problem

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.