ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Command - I need help Please! (https://www.excelbanter.com/excel-programming/362349-vba-command-i-need-help-please.html)

Wendy5

VBA Command - I need help Please!
 

:confused: :confused:

Does anyone know what the proper command in Excel VBA is to "Enter"?
What I mean is that I am programming something in it and the last
required step (so I am told) is to emulate pressing the "Enter" key but
I have no idea how to do that! Any help would be appreciated!!

Wendy


--
Wendy5
------------------------------------------------------------------------
Wendy5's Profile: http://www.excelforum.com/member.php...o&userid=34764
View this thread: http://www.excelforum.com/showthread...hreadid=545256


Tom Ogilvy

VBA Command - I need help Please!
 
Sub BBAA()
SendKeys "~", False
End Sub

--
Regards,
Tom Ogilvy




"Wendy5" wrote:


:confused: :confused:

Does anyone know what the proper command in Excel VBA is to "Enter"?
What I mean is that I am programming something in it and the last
required step (so I am told) is to emulate pressing the "Enter" key but
I have no idea how to do that! Any help would be appreciated!!

Wendy


--
Wendy5
------------------------------------------------------------------------
Wendy5's Profile: http://www.excelforum.com/member.php...o&userid=34764
View this thread: http://www.excelforum.com/showthread...hreadid=545256



Wendy5[_2_]

VBA Command - I need help Please!
 

Thank you for the information but it did not work. Do you have any other
ideas? :confused:


--
Wendy5
------------------------------------------------------------------------
Wendy5's Profile: http://www.excelforum.com/member.php...o&userid=34764
View this thread: http://www.excelforum.com/showthread...hreadid=545256


Dave Peterson

VBA Command - I need help Please!
 
I think I'd go back to that person who said to "enter" the data to find out what
he/she meant.

Wendy5 wrote:

Thank you for the information but it did not work. Do you have any other
ideas? :confused:

--
Wendy5
------------------------------------------------------------------------
Wendy5's Profile: http://www.excelforum.com/member.php...o&userid=34764
View this thread: http://www.excelforum.com/showthread...hreadid=545256


--

Dave Peterson


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com