Navigation

kkbbcc

New Member
Joined
Mar 28, 2005
Messages
12
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.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
What are the cell addresses (in order) you'd like the progression to be?
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,023
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

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
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

Well-known Member
Joined
Jun 19, 2003
Messages
7,985

ADVERTISEMENT

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

New Member
Joined
Mar 28, 2005
Messages
12
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

New Member
Joined
Mar 28, 2005
Messages
12
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,723
Members
410,630
Latest member
JFORTH97
Top