Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab indexing
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab indexing
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. -- Kevin Backmann "ibgolfn" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab indexing
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 On Tue, 15 Jan 2008 15:33:01 -0800, ibgolfn wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indexing | Excel Discussion (Misc queries) | |||
Indexing of Name | Excel Worksheet Functions | |||
indexing problem, I think | Excel Worksheet Functions | |||
Indexing a row | Excel Worksheet Functions | |||
Vlookup - indexing | Excel Worksheet Functions |