Expose more events in VBA
Please can we have the OnKeyPress, OnKeyUp and OnKeyDown events exposed in Excel please?
It is a real and unnecessary pain to have to use the API to do this simple thing.
I don't think we are going to get them. It's been 6 years since my request and since then we have had a whole load of complex things added whilst what would seem to be simple things aren't done.
:-( Look how long it took to get "Unhide All" for worksheets.
Here's hoping though.
And a worksheet_scroll event would be great
Would also love access to OnKeyUp / OnKeyDown events, per cell, while editing worksheets. This could be extremely useful.
Anthony B commented
VBA is not dead.
You need to be a professional programmer to figure out how .Net interacts with Excel, and distribute a result. VBA just works.
Kenneth Barber commented
That would be lovely. When we use the Windows APIs, we kill the portability of our workbooks, since Mac computers do not have the Windows APIs. The burden should be on Microsoft to make their Windows and Mac versions of Excel read keys differently, not on us.
Colin Barrow commented
For a worksheet, BeforePaste and AfterPaste events would be useful as well
Andreas Killer commented
I would appreciate events when rows/columns are un-/hide.
And an on_change event for form buttons, check boxes etc
Jan Wx, NZ commented
Oh yes for example provide the event for row/column insert / delete events please, please, pretty please. Many thanks I bow to you if you do it.