Worksheet_SelectionChange Not recogizing When A Cell Has Changed Value

[Ark68]

I am having difficulty in getting my worksheet_selection change code to work.

In my example, cell W12 has a list validation. When I make a selection from the list, I need some code to run, so I expected that a worksheet_selection code procedure would work.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Stop
    If Not mbevents Then Exit Sub
    tmrow = Target.Row 'trow = Target.Row
    tmcol = Target.Column 'tcol = Target.Column
    If tmcol < 13 Or tmcol > 16 Then
        If Target.Value = "" Then Exit Sub
    End If
    mbevents = False
    . . . more code
end sub

 

[Anthony47]

When you make a selection from a validation list normally you don't change selection; you should rather use the Worksheet_Change event.
Anyway, do you mean that when you change the selection on the worksheet you macro do not reach that Stop?
If you right-click on the tab with the name of the worksheet that you use and select Display Code do you see the code of your Sub Worksheet_SelectionChange?

Additionally (for the next step) where the variable "mbevents" has been declared? Where is it set or reset?

 

[Ark68]

Thank you Anthony for the nudge. I used a worksheet change event instead, and I think now I have it working.
I've not quite grasped the difference between a worksheet change vs. a selection change event.

 

[Anthony47]

Thank you for the feedback