Thread: Cursor Location
View Single Post
  #2   Report Post  
bigwheel
 
Posts: n/a
Default

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