Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Data Validation Dropdown List / Worksheet_Change Event
I'm using Excel 2003. I have the following code associated with my
worksheet: Option Explicit 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").RefersToR ange) Is Nothing Then InterestOnlyPeriod_OnEntry End If If Not boolAutomatedWorksheetChange Then ValidateCostAnalysis Application.Calculate End If ws_exit: Application.EnableEvents = True Application.Calculation = xlCalculationAutomatic End Sub 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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Data Validation Dropdown List / Worksheet_Change Event
This is apparently a bug. Further research turned up this earlier
posting: http://groups.google.com/group/micro...c07358ae7be82a .... which describes a workaround. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation with dropdown list | Excel Discussion (Misc queries) | |||
blanks in data validation list dropdown | Excel Worksheet Functions | |||
Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) | |||
MS Bug? Data validation list dropdown with Worksheet_Change event | Excel Programming | |||
Excel Validation / Dropdown list Problem | Excel Programming |