EXCEL-How to trigger a function with the keyboard enter key
-
Hi, i have a function on in a module. i also have a button on a sheet. how do i trigger the function when i hit the "Enter" key on the keyboard. i tried to record a macro but this doesn't work. any ideas? thanks in advance. Anoop
-
Hi, i have a function on in a module. i also have a button on a sheet. how do i trigger the function when i hit the "Enter" key on the keyboard. i tried to record a macro but this doesn't work. any ideas? thanks in advance. Anoop
The worksheet and workbook objects don't have a KeyDown or KeyPress event, so the only way to tell would be if the sheet is set to recalcuate itself (which it normally does by default) and you handle the Calculate event.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008