Check for Enter key and change focus?

[NooK]

I have a Userform which has a textbox, two Option Buttons and a Ad
button.

The user type something in the box, chooses one of the 2 choices an
press Add (To add the data to a Listbox)

Now what I need is that the user can type the number on the textbo
and press Enter to add the data to the listbox (Assuming the optio
buttons are already chosen), but neither KeyUp or KeyPress events seem
to listen to the Enter Key on the keyboard.

How can this be done?

Another question is that when the user press the add button I woul
like the cursor to go back to the textbox so that he can press Add an
right after type the new data (Without having to click on the text bo
again).

Hopefully they can be done.

Best Regards

Noo

 

[Tom Ogilvy]

Look at the exit event.

Look at setfocus for positioning the cursor.

 

[NooK]

Thanks, the SetFocus worked out nicelly, but the Exit event is not wha
I am looking for because if the user for example clicks anywhere els
in the form (Say the listbox) whatever is in the textbox wil
automatically be aded to it and that's not right, Only if the use
presses Enter is the stuff to be added.

Isn't there anyway at All?

Best Regards

Noo

 

[Tom Ogilvy]

The keyup and keydown events are triggered by a Return.

 

[NooK]

Sorry for the delay on the answer, I was away on vacation with no acces
to internet.

Are you sure Keyup and Keydown are triggered by Enter because i
doesn't do it here.

I did

Private Sub tbData_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVa
Shift As Integer)
MsgBox (KeyCode)
End Sub

And when I press any button on the textbox I get a msgbox saying it'
code but when I press Enter nothing appears and the focus changes t
the next control.

Best Regards

Noo

 

[Tom Ogilvy]

From Help for the Keyup and Keydown events (so yes, Enter does trigger the
event except for the exception cited). Also note the particular information
on Enter when the focus switches - so you should be using the KeyDown. Of
course, a quick trip to the help screen would have cleared this all up for
you.

The KeyDown and KeyUp events do not occur under the following circumstances:

a.. The user presses enter on a form with a command button whose Default
property is set to True.


b.. The user presses esc on a form with a command button whose Cancel
property is set to True.
The KeyDown and KeyPress events occur when you press or send an ANSI key.
The KeyUp event occurs after any event for a control caused by pressing or
sending the key. If a keystroke causes the focus to move from one control to
another control, the KeyDown event occurs for the first control, while the
KeyPress and KeyUp events occur for the second control.