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

  • Thread starter Thread starter Greattude
  • Start date Start date
G

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???
 
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.
 
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
 
Back
Top