Ease of entry on an form designed in excel

C

Chork

Is there a way to enable users who once they enter data into a cell, simply
hit the tab key and move to the next cell requiring data entry?
 
D

Dom_Ciccone

Select all of the cells that you want the user to be able to enter data into,
right click and choose Format Cells. On the Protection tab, uncheck the
"Locked" option. Click OK.

Now go to Tools-->Protection-->Protect Sheet. On the dialog box that
appears uncheck "Select Locked Cells". Click OK. Pressing tab will now move
you between the open cells.
 
G

Gord Dibben

Chork

Sheet event code? You did say "if data is entered".

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub

This is event code which runs when a value is entered in one of the trigger
cells.

Right-click on the sheet tab and "View Code". copy/paste the code into that
module.

For non-VBA methods of moving from one cell to another in sequence see Bob
Phillips's site.

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


Gord Dibben MS Excel MVP
 
Top