View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default How to use ENTER in a TextBox in Excel 2007

Lasse

Set the OK button's Default property to True and it clicks on Enter.
(Likewise, set Cancel buttons Cancel property to true and it clicks on Esc.)

HTH. Best wishes Harald


"Lasse" wrote in message
...
Hi

I have created a Userform containing some OptionButtons, a TextBox, a OK
and
a Cancel button.
I have created a Click behavior for the OK button where I check for which
OptionButtons a user have chosen or if any text is entered in the TextBox.
I would like to add a behavior for the TextBox where I can press ENTER and
it then runs the same macro as pressing the actual OK button.
At the moment when pressing ENTER in the TextBox it moves the focus to the
next object in the tab order.

Any ideas?

/Lasse