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