Pressing Enter after filling a text box

[cmcgath]

I am wondering whether there is a way to program a user form so that, if you press Enter after filling in a text box, it will accept the entry and close the user form without the user having to click on the OK button.

[royUK]

Try this

Please Login or Register  to view this content.

[romperstomper]

Set the Default property of the button to true and pressing Enter will be the same as clicking on it

[cmcgath]

Thanks for the reply. I do not mean a command button. I am asking if there is any way I can use the Enter key after I finish my input into a text box and get the program to accept the value without making the user click on "OK".

[romperstomper]

Your post implied you have a button already. If you don't, then use Roy's code (but it's bad form design IMO).