Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tab" thru cells in a specific order
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tab" thru cells in a specific order
There is no way to set the tab order of cells.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "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
several ways but with a worksheet_change event you could
if target.address="$A$1" then target.offset(1).select if etc -- 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tab" thru cells in a specific order
Why not unprotect the cells you want to 'tab' through, protect the worksheet
and use the tab key to move between the unprotected cells? HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "SteelDetailer" wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tab" thru cells in a specific order
I should've stated that in my original post. The worksheet is protected,
with cells A1-Z9 unlocked. The user can only select unlocked cells. What I want to do is "tab" thru the cells in a specific order. When I enter a value in cell A1, the next cell I want to go to is A2, then A3 (A1-A3 data is related to each other---qty, length, package #). After I enter these, I want to go to B1, not A4. When I've filled out down to row Z, I want to start again at A4, A5, A6, B4, B5, B6, etc. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tab" thru cells in a specific order
Thanks, Don!!
It's a bit or work to get there, but it's what I'm looking for. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tab" thru cells in a specific order
Thanks, Don.
From the info in your first reply, I looked it up in help and began to monkey around with it. I did consider and try the ..then Range("b1").select, too. not sure which way I'll ultimately go, but I appreciate the push in the right direction!!! Rich |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tab" thru cells in a specific order
glad it helped
-- Don Guillett SalesAid Software "SteelDetailer" wrote in message ... Thanks, Don. From the info in your first reply, I looked it up in help and began to monkey around with it. I did consider and try the ..then Range("b1").select, too. not sure which way I'll ultimately go, but I appreciate the push in the right direction!!! Rich |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tab" thru cells in a specific order
Don (or anybody),
I notice that this approach works if the worksheet changes. I'd like the arrow keys to function as they normally would, but the "tabbing" thru the cells to occur only when the "enter" key is used. Thanks, Rich |
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) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | 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) | |||
Backup to specific folder if workbook names begins with "NSR" or "MAC" | Excel Programming |