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?

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?

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?

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?