how I can have the cursor return to the input field

**barrington** · 03-01-2007, 03:50 PM

Hello,

I have a form where the user enters an account number and information about that acount is retrieved and displayed in other fields on the form.

The problem is that the user has to click eac time into the field beore they can enter the next account number.

Tried to use the Set Focus but the cursor still doesn't appear in the field for the user to enter the next account.

Can someone tell me how I can have the cursor return to the input field so that the user can enter the next account number without having to click in the field using the mouse.. A big thank you.

the

**mudraker** · 03-01-2007, 06:35 PM

Setfocus does work. I have used it lots of time.

Are you sure you are trying to use it at the correct loctation in your code.

Posting a copy of wour workbook would help us to give a better answer

Example of using setfocus

Private Sub CommandButton1_Click()
   Me.TextBox1.Text = vbNullString
   Me.TextBox2.Text = vbNullString
   Me.TextBox1.SetFocus
End Sub

**toytinker** · 03-01-2007, 09:38 PM

The simplest way to stay in the same cell after hitting Enter is to go to Tools|Options and select the Edit tab. Uncheck the box next to "Move selection after Enter". You'll save a lot of clicks or arrow key presses!

**barrington** · 03-01-2007, 11:59 PM

Thanks toythinker snd mudraker.

Another question:

I want to execute a routine everytime the ENTER key is pressed. I am using the code shown below. The idea is to allow the processing to take place once the enter key is pressed and not allow the user to click on a command "submit" button.

However, nothing happens when I press the enter key

Public Sub UserForm_Activate()

Application.OnKey "{ENTER}", "Submit"
Application.OnKey "~", "Submit"

End Sub

Can anyone assist me with this issue?