How to use ENTER in a TextBox in Excel 2007

L

Lasse

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
 
H

Harald Staff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Optionbutton Not working 3
DLookup in Continuous form 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Copy value of textbox to clipboard for use in another application 5
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
TextBox change issue 2
Crating User Form to Add Names 1
Enter event in textbox control? 1

Top