Using Drop Down List to Call Macro not Working

[Lexcon07]

I am trying to use a Drop Down List to Call a Macro, but using the drop down list to select a value is not activating the macro. Only deselecting and then re-selecting the cell where the drop down list is located (i.e. $D$7) activates the macro.

Here is my code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Application.Calculation = xlCalculationManual
    Application.ScreenUpdating = False
    If Target.Address = "$D$7" Then
        Call ApplicantDataLoad
    End If
    Application.Calculation = xlCalculationAutomatic
    Application.ScreenUpdating = True
End Sub

The value selected through the Drop Down List, in $D$7, has no relationship to the Macro (i.e. ApplicantDataLoad) itself. The value selected is a variable used in the Macro. I would like the action of selecting a value from the drop down list to activate the macro.

Any suggestions would be greatly appreciated and thanks in advance for taking a look.

 

[Fluff]

If it's a data validation drop down then use the change event instead.Private Sub Worksheet_Change(ByVal Target As Range)

 

[Lexcon07]

Hi Fluff,

That worked!

Thanks!

David

 

[My Aswer Is This]

Answered already will delete my post

 

[Fluff]

You're welcome & thanks for the feedback.