[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Sub Worksheet_Change/Sub Worksheet_SelectionChange

Posted on 2013-11-19
2
Medium Priority
?
348 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 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Gain an elementary understanding of Blockchain technology.
Have you ever run into that annoying problem where the computer won't boot?  Wouldn't it be great if you had a tool that would make that disk boot again?  I have found one tool that works more often than not ...
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…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

656 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