Cell Tab Order

P

Phil Hageman

Is there a way to control tab order among cells - simialar
to Access? For example, in a protected worksheet I want
to tab through the unprotected cells in a particular
order. How would this be done?
 
T

Tom Ogilvy

Range("B1,C21,B2,D14,B4,F12,A3").Select
then use the tab key.

Other than that, you would have to code each move combination in the
selectionchange event.
 
R

Ron de Bruin

Or maybe this Phil

Sub test_1()
Dim myRange As Range
Dim myCell As Range
Dim myAns As Variant

Set myRange = Range("B1,C21,B2,D14,B4,F12,A3")
For Each myCell In myRange.Cells
myAns = InputBox _
(prompt:="Please enter something for cell: " & myCell.Address, _
Title:="Get Data")
If myAns <> "" Then
myCell.Value = myAns
End If
Next myCell
End Sub
 
Top