VBA enter

[paddycorcoran]

How do I simulate hitting the "enter" key in VBA script?

Ive tried SendKeys "{Enter}" and it doesnt work

Thanks

[nigelk]

Put this in as a workbook open event.

Private Sub Workbook_Open()

Application.OnKey "{ENTER}", "MySub"

End Sub

Substitue "MySub" with the name of your own subroutine, then it will run whenever the enter key is pressed.