Keydown event in excel worksheet

[gerard123]

Hi,
Keydown (or keyup or keypress) event can be triggered from a userform, but I can't find how to generate it directly from an excel worksheet.
Since there exist a command "autocomplete", there must be a way to do this. With which vba code??
Can you help.?
Thks
Gerard

[markashworth]

I'd love to know how to do this too. My scenario is that I want to trigger a macro when the user changes a value and presses enter.

The closest I got was adding a worksheet change event to the sheet, then detecting if 1) the value in the cell was changed and 2) the next cell that it goes to is the one below it (happens when the user presses enter, but also happens under other circumstances so its not a brilliant solution as such):

Private Sub Worksheet_Change(ByVal target As Range)
  If target.Address = "$B$4" Then
      Select Case ActiveCell.Address
         Case "$B$5"
              'trigger off the event
              MsgBox "You did it"
 
       End Select
  End If

Would really love to know if anyone had a solution to this.


Mark

Hi,
Keydown (or keyup or keypress) event can be triggered from a userform, but I can't find how to generate it directly from an excel worksheet.
Since there exist a command "autocomplete", there must be a way to do this. With which vba code??
Can you help.?
Thks
Gerard

[Killer42]

Keydown (or keyup or keypress) event can be triggered from a userform, but I can't find how to generate it directly from an excel worksheet. Since there exist a command "autocomplete", there must be a way to do this. With which vba code??

As far as I can tell from the documentation, the key-related events apply only to userforms.

I don't follow your logic on the autocomplete, at all. Excel obviously performs a lot of processing and event-handling which it doesn't expose to VBA.