ENTER instead of TAB

[Guest]

Currently, I have a userform with two input fields. I am unable to advance
from the frist field to the second field via pressing the ENTER button. I
have to use the TAB key. How can I change this?

Thanks,
Les

 

[Roger Govier]

Hi Les

Assuming you are on XL2003 or earlier, Tools>Options>Edit>check Move
after Enter and select direction

 

[Jim Rech]

Roger-

He's referring to a userform, so that setting would have no effect.

Les-

Make sure that each text boxes' EnterKeyBehavior property is set to False.

 

[Roger Govier]

Ooops!!
I had not read userform.
Thanks for pointing it out Jim.