ENTER instead of TAB
 

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

ENTER instead of TAB
 

Hi Les

Assuming you are on XL2003 or earlier, ToolsOptionsEditcheck Move
after Enter and select direction

--
Regards

Roger Govier


"WLMPilot" wrote in message
...
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

ENTER instead of TAB
 

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.

--
Jim
"Roger Govier" wrote in message
...
Hi Les

Assuming you are on XL2003 or earlier, ToolsOptionsEditcheck Move after
Enter and select direction

--
Regards

Roger Govier


"WLMPilot" wrote in message
...
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

ENTER instead of TAB
 

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

--
Regards

Roger Govier


"Jim Rech" wrote in message
...
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.

--
Jim
"Roger Govier" wrote in message
...
Hi Les

Assuming you are on XL2003 or earlier, ToolsOptionsEditcheck Move
after Enter and select direction

--
Regards

Roger Govier


"WLMPilot" wrote in message
...
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