Execute macro based on cell value

Hi,

I have a combo box on Sheet5 where the user chooses one of two options. The combo box spits out "1" or "2" in cell AA7. Then I have two macros: "SPOR" and "Avg_Chk", which change a bunch of calculations on the sheet. I would like the "SPOR" macro to be executed if the value in AA7 is "1" and the "Avg_Chk" macro when the value in AA7 is "2".

I googled and found lots of answers and solutions for this, but when I try to apply them to my worksheet nothing happens when I change the combo box. This is the code I found:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("AA7")) Is Nothing Then
        Select Case Range("AA7")
            Case "1": SPOR
            Case "2": Avg_Chk
        End Select
    End If
    End Sub

I add this to the code of Sheet 5. Macro "Spor" and "Avg_Chk" are saved in a module.

My apologies, I know little to nothing of VBA. I'm sure this is a very obvious mistake and I'm sorry for my noobishness :D

Thank you for your help!

Cheers

M.