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

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???

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

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.

--
__________________________________
HTH

Bob

"Greattude" wrote in message
...
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???

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

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

On Aug 13, 11:28*am, Greattude
wrote:
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???