Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cursor Location
I'm creating a questionnaire that will allow the user to input data in
selected fields. How can I make the cursor advance to the next open cell if the user tabs or hits the enter button? Any assistance would be greatly appreciated |
#2
|
|||
|
|||
First unlock the cells where the user will be entering their response
(FormatCellsProtectionLocked) Then protect the sheet. When you press tab, each of the unlocked cells will be accessed in turn. You could put an instruction to the user to that effect. "Glen" wrote: I'm creating a questionnaire that will allow the user to input data in selected fields. How can I make the cursor advance to the next open cell if the user tabs or hits the enter button? Any assistance would be greatly appreciated |
#3
|
|||
|
|||
While holding down the CTRL key, click on each cell (to highlight them) that you want to allow the users to select. After you have selected the last cell, with the CTRL key still depressed, press the '1' key (not from the numeric keypad, but the !/1 key) to open the Format Cell dialog box. Click on the Protection tab and uncheck the 'Locked' box and click OK. Now, from the main menu, click on ToolsProtectionProtect Sheet. In the box that opens, uncheck 'Select Locked Cells' (enter a password, if desired) and click OK. Now, users will only be able to move between the 'unlocked' cells from the first step. Does this work for you? -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=389136 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|