Commandbutton for moving to a selected cell in a sequence

Hello friends,

I need a button that will allow me to change my selected cell in a sequenced order each time I click the button.

For instance, I want to start on E4, click to move to E5, click to move to E6 and so on. After I get to E15, I need to move to F15 and start moving up one cell after each click. This sequence will continue up and down until I reach T15.

Lastly, a separate button to move back to the previous cell would be nice.

Thanks for you help in advance!

Quote from Carim

Hi,

You could be using the tab key .... to have your cursor behave as required ...and get your tab order for data entry ...

see following link :

http://www.vbaexpress.com/kb/getarticle.php?kb_id=364

Hope this will help

Display More

I tried using the code from the link you provided and it did not work for me. The code was not rejected but pressing the enter or tab key did not perform the desired function.

So I found my error and was able to use this code. However, regardless of which order I type the cells in, it starts at the top of the page once it reaches the bottom cell. I need it to snake.