Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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??? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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??? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel as data entry form? | Excel Discussion (Misc queries) | |||
Can you make a tab entry form in excel like you can in word | Excel Worksheet Functions | |||
excel automatic data entry | Excel Discussion (Misc queries) | |||
data entry form Excel | Excel Discussion (Misc queries) | |||
data entry form in excel | New Users to Excel |