Tab indexing

[ibgolfn]

I think that is what it is called.

How do I get the focus to go through a defined sequence of cells after
hitting tab or enter.

I have made a Questionaire with cells to accept the answers. I would like
the users to be able to jump from one "answer cell" to the next with only one
key stroke (either tab or enter).

Thanks,

Scot

 

[Kevin B]

Select the cell you want to have data entered into and click FORMAT in the
menu & select CELLS. Click the PROTECTION TAB and remove the check from
LOCKED check box and click OK.

Then click TOOLS in the menu and select PROTECTION/PROTECT SHEET. Remove
the check from the SELECT LOCKED CELLS checkbox, add a password if you want
and click OK. The tab key, the enter key or any cursor key will only move
the selection pointer to the next unprotected cell in the worksheet.

 

[Gord Dibben]

If your order of entry is left to right and top to bottom then Kevin's
suggestion is a good one.

If a random order see Bob Phillip's site.

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

You could also use event code to jump around. If interested, post back.


Gord Dibben MS Excel MVP