Trigger to exit macro based on user input of Designated Key.

I'd like to see any example of exiting a macro based on the user typing the letter "K" for example, while the macro is still running.

I understand the escape key works but it also brings up a message box. Is there any code sequence, that would allow a macro to exit based on a user typing the letter "K" at any point INSIDE of the macro's progress? And do without any further error messages?
Or, even to use the escape key but have the message box immediately removed without further user input (not having to select "ok")?

I do apologize for an earlier post related to my same project that was not very well-developed and presented. But in short, if I can't solve this question, I think I can cntr+alt+delete my entire project idea .

Hi thaupert and welcome to ExcelForum,

You can trap any keystroke (such as 'K'), but it requires advanced techniques that may become unstable if not used properly. The EnableCancelKey command will enable you to do special processing when the User presses the 'Esc' key. The built in error module will have a value of 'Err.Number = 18'.

Please Login or Register  to view this content.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis

Thank you so much Lewis! I'm obviously fairly new to macro "writing," although I've recorded many of them and then tweaked. I have a lot of learning to do but am amazed with the power at our disposal when they are done well. I'm overwhelmed with how helpful so many of you are on this site -- across so many different types of questions. I will take a look at this and give it a try. (Thanks, particularly, for proactively guarding me on declaring the variables)