Go to cell based on input

[dazoloko via OfficeKB.com]

Hi all

In hoping someone can help

I have a cell (c16) the user will input a 1 or a zero into.

If its a 1 i want cell (F16) to be selected or if its a 0 cell (C17) to be
selected.

Cheers in Advance

D

 

[Ryan H]

Put this code in the worksheet module.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$C$16" Then
Select Case Target.Value
Case Is = "0": Range("C17").Select
Case Is = "1": Range("F16").Select
End Select
End If

End Sub

Hope this helps! If so, click "YES" below.

 

[dazoloko via OfficeKB.com]

Thanks Ryan

Thats just the job.

D

Put this code in the worksheet module.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$C$16" Then
Select Case Target.Value
Case Is = "0": Range("C17").Select
Case Is = "1": Range("F16").Select
End Select
End If

End Sub

Hope this helps! If so, click "YES" below.

Hi all

[quoted text clipped - 8 lines]

D