VBA - multiple filters from clicking different cells

[jh9940]

Hi

I successfully used the following code:

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection.Count = 1 Then
If Not Intersect(Target, Range("I2")) Is Nothing Then
Call AR1_KS3
End If
End If
End Sub

I have multiple macros that filter data (school grades) e.g., Key Stage 3 - Academic Review 1. My problem is that whenever I add the same code again for another macro it doesn't work and I get the error message: Compile error: Ambiguous name detected: worksheet_selectionChange.

I've now learnt you can't have two of the same and I am not skilled enough to be able to write multiple macros within the same bit of code.

How can I have multiple macros assigned to different cells please?

Huge thanks in advance

JH

 

[Joe4]

OK, that is really a new question altogether, as you are incorporating new procedures (even though it is the same project, it is a different question that your original).
As such, it is best to post that question to a brand new thread, so that it shows up on the "Unanswered threads" listing and other people will see it as a new unanswered question (and improve your chances of having it seen and answered). If you feel it is helpful, you can provide a link back to this question in your new question.

 

[jh9940]

Thank you! Will do
Cheeers