HEY EVERY ONE I HAVE MULTIPLE DATA VALIDATION DROP DOWNS THAT I WANNA RUN A MACRO BASE ON CERTAIN SELECTION I GOT IT WORKING FOR THE FIRST DROP DOWN BUT CAN GET THE SECOND ONE TO WORK

Private Sub worksheet_change(ByVal Target As Range)

If Not Intersect(Target, Range("al9")) Is Nothing Then
Select Case Range("al9")

Case "smooth016": SMOOTH016

Case "smooth020": SMOOTH020

Case "stucco016": STUCCO016

Case "stucco020": STUCCO020

Case " ":

End Select
End If
End Sub

Sub BANDS()

If Not Intersect(Target, Range("AO9")) Is Nothing Then
Select Case Range("AO9")

Case "1/2""": BAND1

Case "BAND2""": BAND2

Case " ":
End Select
End If

End Sub