Hi Steve,

You do need two event macros ...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$V$3" Then
With Target
If .Value = 1 Then
CommandButton1.Caption = "GO TO PART 5"
ElseIf .Value = 2 Then
CommandButton1.Caption = "GO TO PART 9"
End If
End With
End If
End Sub

Private Sub CommandButton1_Click()
If Range("V3").Value = 1 Then
Sheet5.Activate
ElseIf Range("V3").Value = 2 Then
Sheet9.Activate
End If
End Sub

HTH