Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabbing through input worksheet
Rather than creating a complex form with all the associated VBA
coding I have created a worksheet which will transfer information to another sheet - using one macro The input worksheet has input boxes all over the place and I was wondering if it is at all possible to tab or use enter to jump from cells A1 to C4 to D16 etc etc. similar to the way that a created form works Any help would be appreciated Thanks Brian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabbing through input worksheet
A simple way without using VBA would be to protect all the cells in the
worksheet from being selected expect the input cells. Then a tab would go from one input cell to the next. With VBA, an event macro could direct the transitions. -- Gary''s Student - gsnu201001 "BJ&theBear" wrote: Rather than creating a complex form with all the associated VBA coding I have created a worksheet which will transfer information to another sheet - using one macro The input worksheet has input boxes all over the place and I was wondering if it is at all possible to tab or use enter to jump from cells A1 to C4 to D16 etc etc. similar to the way that a created form works Any help would be appreciated Thanks Brian . |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabbing through input worksheet
If your input cells are in aleft to right, top to bottom sequence, unlocking
input cells and Tabbing to them will work. If not in that sequence you can create a named range in the order you want. Start with last cell in order then CTRL + Click your way through the sequence. See Bob Phillips' site for more on this. http://www.xldynamic.com/source/xld.xlFAQ0008.html Gord Dibben MS Excel MVP On Sun, 4 Apr 2010 05:03:33 -0700 (PDT), "BJ&theBear" wrote: Rather than creating a complex form with all the associated VBA coding I have created a worksheet which will transfer information to another sheet - using one macro The input worksheet has input boxes all over the place and I was wondering if it is at all possible to tab or use enter to jump from cells A1 to C4 to D16 etc etc. similar to the way that a created form works Any help would be appreciated Thanks Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel; tabbing through protected worksheet | Excel Discussion (Misc queries) | |||
Sorting after my worksheet has input I want to save | Excel Worksheet Functions | |||
Help! tabbing in worksheet causes excel to freeze | Excel Worksheet Functions | |||
Tabbing on a Protected worksheet | Excel Worksheet Functions | |||
Input data from one worksheet to another | Excel Discussion (Misc queries) |