Unloading a form using the ESC key

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

Thanks

John

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]

Cheers mate, much appreciated.