Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The Tab Function (Take 2)
Just a quick one.
In a worksheet, pressing the tab key allows the user to move to the next cell to the right. Is there a way to restrict which cells the user can go to? For example the cursor starts off in cell A5 and when the tab key is hit the cursor moves to cell A10 instead of B5? Cheers, D |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
The Tab Function (Take 2)
Just a thought, you might want to pop the following line
in somewhere to disable to tabbing Application.OnKey "{TAB}" Cheers. -----Original Message----- Just a quick one. In a worksheet, pressing the tab key allows the user to move to the next cell to the right. Is there a way to restrict which cells the user can go to? For example the cursor starts off in cell A5 and when the tab key is hit the cursor moves to cell A10 instead of B5? Cheers, D . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
The Tab Function (Take 2)
See alternate methods in answer to your first post.
Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Tue, 15 Jul 2003 20:03:52 -0700, "Darren O'Connell" wrote: Just a quick one. In a worksheet, pressing the tab key allows the user to move to the next cell to the right. Is there a way to restrict which cells the user can go to? For example the cursor starts off in cell A5 and when the tab key is hit the cursor moves to cell A10 instead of B5? Cheers, D |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
The Tab Function (Take 2)
I think you read Gord's intent wrong. I read it as a reminder to the original
poster that he/she has another response and they might like to go back there and look at it. Don wrote: Nice to see the friendlyness in this forum. These forums are for helping other's, and sharing ideas. Just because another person puts forward a possible solution (no matter how incorrect it is), doesn't mean you should blatantly criticise them. You should think about getting some manners before you post again. -----Original Message----- See alternate methods in answer to your first post. Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Tue, 15 Jul 2003 20:03:52 -0700, "Darren O'Connell" wrote: Just a quick one. In a worksheet, pressing the tab key allows the user to move to the next cell to the right. Is there a way to restrict which cells the user can go to? For example the cursor starts off in cell A5 and when the tab key is hit the cursor moves to cell A10 instead of B5? Cheers, D . -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
The Tab Function (Take 2)
Don
Dave is correct stating my intent. I criticised no one, blatantly or otherwise. Your perception of events, of course, is strictly that.......yours, but it serves as a reminder to us all that one man's Mede is another man's Persian. Gord On Tue, 15 Jul 2003 23:23:21 -0500, Dave Peterson wrote: I think you read Gord's intent wrong. I read it as a reminder to the original poster that he/she has another response and they might like to go back there and look at it. Don wrote: Nice to see the friendlyness in this forum. These forums are for helping other's, and sharing ideas. Just because another person puts forward a possible solution (no matter how incorrect it is), doesn't mean you should blatantly criticise them. You should think about getting some manners before you post again. -----Original Message----- See alternate methods in answer to your first post. Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Tue, 15 Jul 2003 20:03:52 -0700, "Darren O'Connell" wrote: Just a quick one. In a worksheet, pressing the tab key allows the user to move to the next cell to the right. Is there a way to restrict which cells the user can go to? For example the cursor starts off in cell A5 and when the tab key is hit the cursor moves to cell A10 instead of B5? Cheers, D . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |