I have a problem with SendKeys Function. Im Using Excel 2003 in Windows 7.
I have 2 Functions OKReturn and OKDown and they are being Mapped to Keys
Application.OnKey "{ENTER}", "OKReturn"
Application.OnKey "{DOWN}", "OKDown"
This is what my fuctions look like:
Sub OKReturn()
...
Call Application.SendKeys("{DOWN}", True)
End Sub
Sub OKDown()
...
End Sub
For some reason when I send DOWN key to application from OKReturn it never goes in OKDown function even though the DOWN button is mapped. But when I do it directly it works for example : Call OKDown. Is this a bug in Excel or am missing something. Thanks
Bookmarks