How do I make tab automatic in an excel data entry form?

[Greattude]

I have created a form for our salespeople and I want to have excel
automatically move the cursor to the data entry areas so they have to fill it
in before moving on???

 

[Bob Phillips]

Private Sub Worksheet_Activate()
Me.Range("A1").Select
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

 

[JP]

In addition to Bob's suggestion, you could also employ some VBA code
to check the values of the data entry cells to see if they are non-
empty and/or contain the type of information you need, before allowing
the end user to complete the form.

--JP