Switching between textboxes

I have a form which has 19 textboxes aligned in a column that the user inputs values into. Right now they have to click in each textbox to enter data.

Is there a way that after entering a value, the next textbox down can be selected using either the down arrow or when hitting "Enter" (also preferrably switching to the textbox above when hitting the up arrow).

I should note that I currently have some code being run everytime a textbox is changed to update the output fields (using textbox1_change() routine).

Any help would be greatly appreciated, I've looked around and haven't been able to find anything that works as of yet.

It's not on a userform, but on a worksheet that I've added a data entry area.

This seemed to work for me:

Please Login or Register  to view this content.

I tried using something like that, but I really need to retain the textbox1_change() event, because I need the data to be updated real-time.

When I use the textbox1_KeyDown() routine the sata doesn't update with every keystroke, but rather with the next keystroke. This produces mis-leading output values.

Is there anyway to include the KeyCode logic within a _change() routine?

Using the following code (containing both change and keydown) my cells A1, A2, & A3 all change in realtime.
Can you attach a sample so we can see the issue more clearly?

Please Login or Register  to view this content.

I actually just tried that before you posted and it works great! I was not aware you could run them at the same time.

Two smaller issues:

1. Can you select all the text in a textbox after the .activate? That way the user doesn't have to delete what is in there manually

2. In the following code, I've written it for textbox1 on my sheet. Can I write one section of code that will drop to the next textbox based on the current textbox? Rather than write the below code for all 19 of my textboxes (i.e. if in textbox5, then go to either textbox 4 or 6)

Please Login or Register  to view this content.

Originally Posted by jcup

Two smaller issues:

1. Can you select all the text in a textbox after the .activate? That way the user doesn't have to delete what is in there manually

2. In the following code, I've written it for textbox1 on my sheet. Can I write one section of code that will drop to the next textbox based on the current textbox? Rather than write the below code for all 19 of my textboxes (i.e. if in textbox5, then go to either textbox 4 or 6)

1. See this link for example using .SelStart and .SelLength: Select text in textbox

2. If this is possible, it is beyond my abilities at this time. I recommend just copy/pasting and changing the numbers for each textbox.

Hope that helps.