keypress down question 1

[NeverEnds]

I know this is a very simple problem, but I didn't find anything about it on the forum. In excel, I have an entry textbox and everytime the user presses the enter key in that textbox, I want it to be the same as if they pressed the submit button which I've already coded. Thanks for any help in advance.

 

[PHV]

Have you tried to set the Default property of the submit button to True ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[NeverEnds]

That definitelly works. I wasn't using a dialog box at first(no idea why), but now that I am, I set the button to default and it works just fine. Thanks for your help.