moving to a specific cell based on another cell value

T

Triple

I know about the go to function in excel, but is there a way to jump
to a cell based on value of another cell?

EX: If cell A1 = "duct" then jump to A3.
If cell A1 = "fittings" then jump to A3005

Any help would be greatly appreciated!
 
H

Hawkide

Paste the following code into the VBA module for the worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub

If Range("A1").Value = "duct" Then
Range("A3").Activate
ElseIf Range("A1").Value = "fittings" Then
Range("A3005").Activate
End If
End Sub
 
Top