View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default UserForm Keyboard Control

For the CommandButton that you want "clicked" when the Enter key is
pressed... set its Default property to True.

For the CommandButton that you want "clicked" when the Esc key is pressed...
set its Cancel property to True.

--
Rick (MVP - Excel)


"DoctorG" wrote in message
...
I am new in Forms design. Can anyone tell me how to activate or specify the
use of Enter and Esc keys in a form so that they represent a positive and
a
negative user choice?