How to make keyboard ENTER in VBA ? 3

[modzho]

In my macro there is a soft Message Box what always appears and as my function repeats I need to push ENTER on my keyboard each time to continue the macro. It is not microsoft programm and there is no way to turn off this dialog box.
anybody have idea how to say keyboard enter in VBA macros ?

thanks.

 

[SkipVought]

Hi,

What does the Message Box state?

Sometimes adding

Application.DisplayAlerts = False
... you code

Application.DisplayAlerts = True

can help.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[JohnAcc]

You can use the sendkeys method if the msgbox is being called by another programme

The syntax for Enter is: {ENTER}

Rgds, John

 

[xlbo]

Application.SendKeys("{ENTER}&quot
or
Application.SendKeys("{RETURN}&quot
or
Application.SendKeys("~&quot

depending on which kinda "enter" you do

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[modzho]

Thank you very much !!!
Its works !!!