VBA - Worksheet Change not working

[pacittm]

I am trying to get this code to run a macro based on the number in cell C7.
All of the macros work perfectly, but I can't get the worksheet change to trigger them.
Here's the code -

Private Sub Worksheet_Change(ByVal Target As Range)
   Set Target = Range("C7")
   Application.EnableEvents = False
   If Target Is Nothing Then
   Call ROWNULL
   End If
If Not Intersect(Target, Range("C7")) Is Nothing Then
    If Target.Value = 1 Then
    Call ROWONE
    Else
         If Target.Value = 2 Then
          Call ROWTWO
    Else
             If Target.Value = 3 Then
                 Call ROWTHREE
    Else
                 If Target.Value = 4 Then
                  Call ROWFOUR
    Else
                     If Target.Value = 5 Then
                      Call ROWFIVE
    Else
                         If Target.Value = 6 Then
                          Call ROWSIX
    Else
                             If Target.Value = 7 Then
                              Call ROWSEVEN
    Else
                                 If Target.Value = 8 Then
                                  Call ROWEIGHT
    Else
                                    If Target.Value = 9 Then
                                      Call ROWNINE
    Else
                                                                             Call ROWNULL
    End If
    End If
    End If
    End If
    End If
    End If
    End If
    End If
    End If
    End If
    End If
    Application.EnableEvents = True
    
End Sub

Any help would be appreciated!

 

[RoryA]

Does C7 contain a formula? If so, it won't trigger the Change event - you'd have to use the Worksheet_Calculate event or monitor the input cells to the formula instead.

 

[pacittm]

No, it just contains a number - it's for the user to input a value.

 

[RoryA]

Perhaps events have become disabled. In the VB Editor, open the Immediate window (Ctrl+g), type this in and press enter:

Application.EnableEvents = True

then try changing the number in C7 again.

If it still doesn't work, do the users enter the number into the cell directly or using data validation, or a control?

 

[pacittm]

I'm afraid that didn't seem to do anything - I do have that text in my code as well, if that helps?

I'm afraid not - it's just a question of typing in a number.

 

[pacittm]

Ah never mind - I pasted it into the wrong window - thank you! That works a treat!!

 

[RoryA]

Glad to help.