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?

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.
--
Kevin Ciccone


"Chork" wrote:

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?

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

On Thu, 24 May 2007 06:05:01 -0700, Chork
wrote:

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?