Data Validation Drop Down List To Trigger Macro

[pure vito]

Hi All,

Hopefully just a quick one

My aim here is to use "C3" dropdown selection to trigger a macro based on the value, I have used Data Validation to populate the dropdown,

I have a working VBA that when text is entered manually into "C3" it runs the macro and it works fine but I can't seem to get the same result with the dropdown list,

I have been looking online for a solution but have just been coming across the same VBA,

Thanks in advance,

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("C3")) Is Nothing Then
        Select Case Range("C3")
            Case "Base Set Series": Baseset
           
        End Select
    End If
End Sub

 

[Peter_SSs]

I think that if you had looked closely at the second message box, the culprit space would have been visible.

 

[pure vito]

That's great tool to make use of in the future thanks Peter, I was going to post the screen shot of that but for whatever reason didn't it's the little things