+ Reply to Thread
Results 1 to 2 of 2

SendKeys Issue

Hybrid View

pavel3002 SendKeys Issue 06-08-2011, 05:32 PM
Mordred Re: SendKeys Issue 06-08-2011, 05:35 PM
  1. #1
    Registered User
    Join Date
    06-08-2011
    Location
    Sacramento, California
    MS-Off Ver
    Excel 2003
    Posts
    7

    SendKeys Issue

    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
    Last edited by pavel3002; 06-08-2011 at 05:42 PM.

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: SendKeys Issue

    Hi pavel3002 and welcome to the forum. Please take some time to read the forum rules located here and wrap your code in code tags.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1