Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation list does not trigger worksheet_change event
if a user selects a value from a data validation list the VBA code is not
executing, how do i fix this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation list does not trigger worksheet_change event
i have something similar. mine is in c2, this may work
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count = 1 Then If Not Intersect(Target, Range("C2")) Is Nothing Then Call Threshold Else 'Exit Sub End If End If End Sub -- Gary "ivory_kitten" wrote in message ... if a user selects a value from a data validation list the VBA code is not executing, how do i fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Data Validation Dropdown List / Worksheet_Change Event | Excel Programming | |||
In what version was the change event on a data validation list fixed? | Excel Programming | |||
trigger event if any data in modified on ONLY the current workshee | Excel Programming | |||
Event Procedure - Data Validation List | Excel Programming | |||
MS Bug? Data validation list dropdown with Worksheet_Change event | Excel Programming |