+ Reply to Thread
Results 1 to 2 of 2

Retrieve keystrokes to VBA

  1. 03-13-2009, 02:46 AM #1
    neta
    neta is offline
    Registered User
    Join Date
    03-26-2004
    Posts
    35

    Retrieve keystrokes to VBA

    Hi,
    How can I receive the keystroke of a keyboard, into VBA code, when using the Private "Sub Workbook_SheetChange".
    For example - when a user hit the "Delete" key on the keyboard, the "Private Sub Workbook_SheetChange" is activated. I want to receive the code for the "Delete" key to the VBA code.
    Thanks, neta
    Reply With QuoteRegister To Reply
  2. 03-13-2009, 02:58 AM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Retrieve keystrokes to VBA

    Hello neta,

    Excel doesn't provide any feedback to VBA about keystroke events.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1