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

--
Message posted from http://www.ExcelForum.com

Look at the exit event.

Look at setfocus for positioning the cursor.

--

Regards,
Tom Ogilvy

"NooK " wrote in message
...
I have a Userform which has a textbox, two Option Buttons and a Add
button.

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

Now what I need is that the user can type the number on the textbox
and press Enter to add the data to the listbox (Assuming the option
buttons are already chosen), but neither KeyUp or KeyPress events seems
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 would
like the cursor to go back to the textbox so that he can press Add and
right after type the new data (Without having to click on the text box
again).

Hopefully they can be done.

Best Regards

NooK


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

The keyup and keydown events are triggered by a Return.

--
Regards,
Tom Ogilvy

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

Isn't there anyway at All?

Best Regards

NooK


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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.



--

Regards,

Tom Ogilvy



"NooK " wrote in message
...
Sorry for the delay on the answer, I was away on vacation with no access
to internet.

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

I did

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

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

Best Regards

NooK


---
Message posted from http://www.ExcelForum.com/