Submiting A Excel using enter

[sebhughes]

How can I make it so the enter key to submit the form?

 

[erik.van.geit]

Hi,

please be more specific ?
are ou talking about a userform ?
by "submit" do you mean pressing an OK-button to perform some operations ?

kind regards,
Erik

 

[sebhughes]

I have a form and i want the enter data button to be activate by the enter key. So say the form is all filled in, when they press enter it will send the data to where it shoudl go.

 

[erik.van.geit]

you can set the taborder

example
userform: 2 textboxes + 1 commandbutton

fill in textbox1
press TAB (going to textbox2)
fill in textbox2
press TAB (going to commandbutton)
press ENTER while your commandbutton is active

you might want to take a look at TABORDER
(rightclick your userform, see last option)