View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Unloading a form using the ESC key

Hi John,

johncassell wrote:
Hello, Is there anyway to be able to unload a form by pressing the ESC
key.


Yes. If you have an existing "Cancel" button, set its Cancel property to
True. If you don't, you'll need to create a Cancel button and set its
Cancel property to True. Then put some code behind its Click event that
unloads or hides the userform.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]