I have a spreadsheet that requires someone to input data into certain cells
within the sheet. How can I set up the sheet so that when I hit the TAB key
it automatically move the cursor to a cell that requires user input of
information only?
I know this can be done. This is an urgent matter as I need toresolve this
before the end of the secon week in August 2008.
Thank you in advance.

See if this old post helps:

http://tinyurl.com/3kksgy

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"adrian19622007" wrote in message
...
I have a spreadsheet that requires someone to input data into certain
cells
within the sheet. How can I set up the sheet so that when I hit the TAB
key
it automatically move the cursor to a cell that requires user input of
information only?
I know this can be done. This is an urgent matter as I need toresolve this
before the end of the secon week in August 2008.
Thank you in advance.

See Bob Phillips' site for a couple of methods to set the Tab order.

Includes the named range approach posted by RagDyer.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is also a VBA method using sheet event code if you want it.

Post back if so.


Gord Dibben MS Excel MVP


On Fri, 25 Jul 2008 23:32:00 -0700, adrian19622007
wrote:

I have a spreadsheet that requires someone to input data into certain cells
within the sheet. How can I set up the sheet so that when I hit the TAB key
it automatically move the cursor to a cell that requires user input of
information only?
I know this can be done. This is an urgent matter as I need toresolve this
before the end of the secon week in August 2008.
Thank you in advance.

adrian19622007 wrote:
I have a spreadsheet that requires someone to input data into certain cells
within the sheet. How can I set up the sheet so that when I hit the TAB key
it automatically move the cursor to a cell that requires user input of
information only?
I know this can be done. This is an urgent matter as I need toresolve this
before the end of the secon week in August 2008.
Thank you in advance.


You could use worksheet protection + cell locking.

By default, all cells are locked but this has no effect unless the
worksheet is protected.

To accomplish what you want, select each of the cells in which input is
needed, and uncheck the Locked property on the format | cell |
protection dialog.

After unlocking all the cells needed, protect the worksheet on the tools
| protection | worksheet dialog.

Now, the tab key will cycle through the unlocked cells only.