Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tab" thru cells in a specific order
Is there an event I could use to fire this code only if the "enter" key is
pressed after changing the value of the active cell? The code below essentially does what I want by runing anytime the cell value is changed. However, I'd like the arrow keys to work "normally"....sometimes I want to change the values in all of the cells in column 3 and I want the arrow key to go down instead of to the down one and left 2. Thanks!! Rich "Don Guillett" wrote: right click sheet tabview codeinsert thismodifySAVE Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Target.Offset(1).Select If Target.Address = "$A$2" Then Target.Offset(1).Select If Target.Address = "$A$3" Then Target.Offset(-2, 1).Select 'or 'If Target.Address = "$A$3" Then Range("b1").Select End Sub -- Don Guillett SalesAid Software "SteelDetailer" wrote in message ... I need to be able to "tab" or "enter" thru cells in a specific order. For example, I will be entering data into cells A1 thru Z9. he data in A1, A2 & A3 are related to each other, as is B1-B3, C1-C3, A4-A6, B4-B6, A7-A9, B7-B9,etc. How do I make the "tab order" be A1, A2, A3, B1, B2, B3, C1......A4, A5, A6, B4, B5, B6......etc.? I use the term "tab order" because, if I recall correctly, that is the name of the VB property for objects in VB forms. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tab" thru cells in a specific order
If you want the same values all the way down try the following in your code
(make sure you substitute the ranges accordingly): Range("I5").Select Selection.AutoFill Destination:=Range("I5:I32"), Type:=xlFillDefault JNW "SteelDetailer" wrote: Is there an event I could use to fire this code only if the "enter" key is pressed after changing the value of the active cell? The code below essentially does what I want by runing anytime the cell value is changed. However, I'd like the arrow keys to work "normally"....sometimes I want to change the values in all of the cells in column 3 and I want the arrow key to go down instead of to the down one and left 2. Thanks!! Rich "Don Guillett" wrote: right click sheet tabview codeinsert thismodifySAVE Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Target.Offset(1).Select If Target.Address = "$A$2" Then Target.Offset(1).Select If Target.Address = "$A$3" Then Target.Offset(-2, 1).Select 'or 'If Target.Address = "$A$3" Then Range("b1").Select End Sub -- Don Guillett SalesAid Software "SteelDetailer" wrote in message ... I need to be able to "tab" or "enter" thru cells in a specific order. For example, I will be entering data into cells A1 thru Z9. he data in A1, A2 & A3 are related to each other, as is B1-B3, C1-C3, A4-A6, B4-B6, A7-A9, B7-B9,etc. How do I make the "tab order" be A1, A2, A3, B1, B2, B3, C1......A4, A5, A6, B4, B5, B6......etc.? I use the term "tab order" because, if I recall correctly, that is the name of the VB property for objects in VB forms. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with macro, setting "tab order" of unprotected cells | Excel Discussion (Misc queries) | |||
Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
"Extract" specific values from cells | Excel Discussion (Misc queries) | |||
"tab" thru cells in a specific order | Excel Programming | |||
Backup to specific folder if workbook names begins with "NSR" or "MAC" | Excel Programming |