Solved

Sub Worksheet_Change/Sub Worksheet_SelectionChange

Posted on 2013-11-19
2
323 Views
Last Modified: 2013-11-20
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
0
Comment
Question by:jvantassel1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
Michael earned 500 total points
ID: 39660949
The Worksheet_Change etc. procedures must reside in the private module of the Worksheet Object. Not in a standard module.

Joop
0
 
LVL 1

Author Closing Comment

by:jvantassel1
ID: 39663734
Thanks, helped very much.
0

Featured Post

Turn your laptop into a mobile console!

The CV211 Laptop USB Console Adapter provides a direct Laptop-to-Computer connection for fast and easy remote desktop access with no software to install.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Gain an elementary understanding of Blockchain technology.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question