Sub Worksheet_Change/Sub Worksheet_SelectionChange

trying to apply autofilter when a value is selected from  a dropdown (instead of the current active X control).  However, neither Sub Worksheet_Change or Sub Worksheet_SelectionChange is activated when the dropdown value is selected.

Cell "E10", named range "PEGclearDates" is the cell.

thanks for the help
POM-1620-Murder-Board-Dates-and-.xlsm
LVL 1
jvantassel1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
MichaelConnect With a Mentor Business AnalystCommented:
The Worksheet_Change etc. procedures must reside in the private module of the Worksheet Object. Not in a standard module.

Joop
0
 
jvantassel1Author Commented:
Thanks, helped very much.
0
All Courses

From novice to tech pro — start learning today.