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)