Pausing VBA Code

[DragonTech]

Re: Pausing VBA Code - SOLVED

I actually replaced the On Enter event with the On Key Press event, using "KeyAscii = vbKeyReturn". Thank you for all your help, Paul! Your method works very nicely!

 

[pbaldy]

Happy to help! I wouldn't use the keypress event since it fires with every key stroke, but I suppose that's personal preference. You might also want to check for the tab key, as some people tab out of controls.