Solved

Sub Worksheet_Change/Sub Worksheet_SelectionChange

Posted on 2013-11-19
2
304 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
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Software to generate custom JPGs 12 127
cloning computer 13 94
forgot pst password 2 53
Keep Ditto Clipboard Manager open for multiple pastes 6 50
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

809 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