Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet setup where there are 4 data entry columns. The
other columns are locked and cannot be selected. This application is intended for live data entry and speed in entry is extremely important. One of the data entry columns is a "Comment" column that will rarely be selected. As the user enters data, I would like for the active cell to go A1, B1, C1, A2, B2, C2, A3... each time they press the tab key. I only want them to go to column D (comment column) if they actually move the cursor to that column and select a cell. As it is right now of course, the user has to press tab twice after entering column C data in order to get back to column A. I would like to avoid that 2nd tab entry if it is possible. Thanks. Sterling |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I stop "global" hyperlinks changing to "local" links? | Excel Worksheet Functions | |||
HELP! Clicking "$" button changes format to ";;" not what it shoul | Excel Discussion (Misc queries) | |||
Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
Changing data source in pivot table- "Back" button is disable | Excel Discussion (Misc queries) | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |