Navigation

[kkbbcc]

I have created a number of forms in Excel. What I need is a way to program navigation from one cell to the next by tabbing. The default of moving one cell to the right is insufficient. I want to be able to determine which cell that will be focused upon next. What I am seeking, I guess, is a "goto" formula.

 

[Oaktree]

What are the cell addresses (in order) you'd like the progression to be?

 

[tusharm]

Don't know what VBA forms have to do with XL navigation...

A simple way to jump through a series of predetermined cells: Unlock the cells that you want to navigate to. Then, protect the worksheet.

I have created a number of forms in Excel. What I need is a way to program navigation from one cell to the next by tabbing. The default of moving one cell to the right is insufficient. I want to be able to determine which cell that will be focused upon next. What I am seeking, I guess, is a "goto" formula.

 

[Oaktree]

Don't know what VBA forms have to do with XL navigation...

Not all forms are VBA forms, Tushar. My guess is that the OP just meant form letters or templates of that nature.

 

[Datsmart]

If you are talking about the order objects in a Userform are selected using the Tab key, then...
In the VBA editor, select your userform, click "View" | "Tab Order".
The dialog box that pops up allows you to choose the order items are selected when you hit the Tab key.

 

[kkbbcc]

Thank you for your replies. I think I would have to send you a copy of one of the forms so that you could "tab" through and see how the order of cell focus often does not make sense.

Please let me know if that would help you to better see my problem.

 

[kkbbcc]

Thank you for your replies. I think I would have to send you a copy of one of the forms so that you could "tab" through and see how the order of cell focus often does not make sense.

Please let me know if that would help you to better see my problem. If so, please let me know how to e-mail the form to you.