TABBING BETWEEN PARTICULAR CELLS

[adrian19622007]

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.

 

[Ragdyer]

See if this old post helps:

http://tinyurl.com/3kksgy

 

[Gord Dibben]

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