Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I advance to the next field automatically?
I have a template that I have created that is to be used for data entry. I
have a validation on each cell that allows no more than one character. What I would like happen is once that character is entered, it automatically goes to the next cell w/o having to use the Enter/Tab/Arrow Rgt keys. For example, for the last name, there is a field for each alpha of the last name and right now I have to enter each alpa and then tab to the next field and type in the second letter of the last name and then so on and so on. I just want to be able to type continuously and have each alpha placed in the corresponding column. I know there has to be a way. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to automatically advance a number when printing? | Excel Worksheet Functions | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
pivot chart is it possible to hide individual field buttons? Layout Field buttons | Charts and Charting in Excel | |||
Conditional Formatting of Pivot Table Field | Excel Discussion (Misc queries) | |||
how can i automatically insert cell values into a comment field? | Excel Discussion (Misc queries) |