Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
bug: Worksheet_Change clashes with dropdown list validation.
This code:
Private Sub Worksheet_Change(ByVal rngTarget As Range) Debug.Print "Worksheet_Change" & "(" & rngTarget.Address & ")" & Application.Ready Application.EnableEvents = True Application.Calculation = xlCalculationManual rngTarget.Font.Bold = True Debug.Print "rngTarget.Font.Bold " & rngTarget.Font.Bold Application.Calculation = xlCalculationAutomatic End Sub Generates this output when editing a cell: Worksheet_Change($BA$30)True Got Here rngTarget.Font.Bold True But generates this output when picking from a data validation list: Worksheet_Change($BA$30)True Got Here rngTarget.Font.Bold False Ergo the assignment bold does not work and does not generate an error. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Dropdown list starts at b ottom of list | Excel Discussion (Misc queries) | |||
Create validation list with Worksheet_change | Excel Programming | |||
data validation list does not trigger worksheet_change event | Excel Programming | |||
Problem with Data Validation Dropdown List / Worksheet_Change Event | Excel Programming | |||
MS Bug? Data validation list dropdown with Worksheet_Change event | Excel Programming |