Vba experts: Executing a macro when certain cells are selected

[bamaisgreat]

Is there away to execute a macro after selecting a few certain cells???

 

[bamaisgreat]

I keep getting a compile error:Ambiguous name detected:Worksheet_SelectionChange

I have a Selection Change in the sheet code already, that may be messing it up.
Here is everything in the Sheet Code

Then one you made is at the bottom. Thanks

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address = "$G$1:$J$1" Then
Call FINALIZED_BY_QC_job
End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address = "$A$4,$J$10" Then
Call SHOW_LIST
End If
End Sub

 

[Andrew Poulsom]

You can only have one procedure for each event. Try:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) 
    If Target.Address = "$G$1:$J$1" Then
        Call FINALIZED_BY_QC_job
    ElseIf Target.Address = "$A$4,$J$10" Then
        Call SHOW_LIST
    End If
End Sub

 

[bamaisgreat]

Andrew, as soon as I select any cell this error comes up Compile error: Expected variable or procedure,not module. And it highlights the Call SHOW_LIST

Im not sure what this means, SHOW LIST is a macro.

 

[Andrew Poulsom]

Make sure that the procedure SHOW_LIST isn't in a module with the same name. Change the name of the module if necessary.

 

[bamaisgreat]

ok makes since. I noticed that I have to hold down the CTRL button while selecting the cells, Is this correct?

 

[Andrew Poulsom]

Yes, that's how you make a discontiguous selection.

 

[bamaisgreat]

ok, thanks again