March 25th, 2001, 12:06 PM
MS Excel - can you change TAB order as you go from cell to cell
I know you can configure Excel to either go to the next cell to the right or the next cell down when you hit the tab/enter key but can you tell it what cell specifically to go to next after you hit the enter/tab key. I have made up a form using only the basics in Excel and in areas of the form you have to use the arrow keys in order to get to the next entry cell which may be as much as 5 key strokes in different directions. Would be easier to use something in excel to do this for you. Would a macro do this?
Just as an example I would want with only one key stroke when I depress the enter/tab key for the active cell to go from C1 to C6
March 25th, 2001, 08:45 PM
Since you say your worksheet is a form, you can achieve your aims by protecting the sheet but leaving your "data entry" cells unlocked.
Firstly select the cells you want users to be able to type in, go Format/Cells/Protection
Take the tick out of "Locked".
Then Tools/Protection/Protect Sheet = OK (Don't enter a password).
Now your users will only be able to enter data in your selected cells and pressing TAB key will cycle around the cells from top Left to bottom right by rows.
Please remember that others may need to know the outcome of your problem so please keep us updated.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)