View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] eoleo.ftp@googlemail.com is offline
external usenet poster
 
Posts: 2
Default Closing Form on pressing Enter or Return-key

Hallo,

in my UserForm I use a combobox that takes the focus, when the Form
opens. By using shortcut Ctl+D a dropdown is executed so the user is
able to select entries by using the arrow-keys.

Now I would like the programm to act as follows: If the user presses
the return or enter-key the form should close.
How can I reach that?

Thanks in advance.
Leo