onkey vba

  1. H

    Change the list contents in a cell, when changing the contents in another cell.

    The user fill in these cells: D5, D6, D7, D9 and D10. Other cells are locked, so with Tab, Enter or Arrows, you step through these cells. D5 and D7 are pull down lists with 10 different alternatives each. Normally you start with selecting someting in the D5 list. Depending on what you select in...
  2. D

    Left arrow key will not behave

    Hello All, In order to make the 'Up' and 'Down' arrow keys work properly, I am using some code like the following: First, the Worksheet Selection Change event: If Target.Row = 49 Or Target.Row = 58 Then Application.OnKey "{Up}", "NextUp_toRow31" GoTo UpArrowEnd End If and then, in a...
  3. A

    OnKey not working in Userform

    I have set up a Userform in Excel 2013 with lots of Toggle and Command Buttons. I want to be able to set up some Function Keys (eg F1 to F5) that run some of the same procedures called by the Command buttons, so that the user has a choice of either clicking a Command button or pressing F2 (for...
  4. J

    How To "Share" Default Behavior With OnKey?

    Halo I want to run a macro with OnKey, but then I want the normal key behavior to execute. Neither of these two approaches work; both produce an endless loop. I'd like a solution which will work with ANY single or combination keystroke. Sub keyEvent() Debug.Print "a typed" With...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top