I solved the problem my self. I used the setfocus option.

Thanks

"Jared" wrote:

I do want to use the keydown event but i do not know how to select a textbox
using a macro

thanks


"Jim Rech" wrote:

You might be able to accomplish what you want using the KeyDown or KeyPress
events. However I think the UI design you're considering will be very
frustrating for your users. You're planning to take away all their editing
keys. How can a user backspace over a mistyped entry or maneuver within the
text box to change something that was typed?

--
Jim
"Jared" wrote in message
...
I have creatd a userform. I am trying to enable the cursor keys (up, left,
right, down and delete)

I want the user to be able to press the arrow keys so the cursor will go
to
the respected textbox. i also want to enable that when the backspace is
pressed in an empty cell the cursor will jump to the text box before this
one.

any suggestions?