Problem with Data Validation Dropdown List / Worksheet_Change Event
I'm using Excel 2003. I have the following code associated with my
Private Sub Worksheet_Change(ByVal Target As Range)
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
On Error GoTo ws_exit
boolMinimumInfoCompleted = False
boolErrorsFound = True
boolAutomatedWorksheetChange = False
If Not Application.Intersect(Target,
ThisWorkbook.Names("InterestOnlyPeriod").RefersToRange) Is Nothing Then
If Not boolAutomatedWorksheetChange Then
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
Here's the problem. "InterestOnlyPeriod" is the name of a cell that
contains a data validation drop-down list. I've established that the
Worksheet_Change event fires if I type a selection in the
"InterestOnlyPeriod" cell or if I make a selection from the drop-down
list. However, the first If..Then statement above only evaluates as
"True" if I physically type a selection in the "InterestOnlyPeriod"
cell. If I make a selection from the drop-down list, Worksheet_Change
fires, but this If..Then statement evaluates as false.
Any ideas? Does "Target" have a different value if a selection is made
from the drop-down list?
Re: Problem with Data Validation Dropdown List / Worksheet_Change Event
This is apparently a bug. Further research turned up this earlier
.... which describes a workaround.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1