| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
| Enter data and press enter to move to specific cell | Excel Programming | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
Linear Mode
