Cell Tab Order

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
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?
 
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.
 
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
 
Back
Top