Thread
:
Change event for data validation listbox
View Single Post
#
2
Posted to microsoft.public.excel.programming
Bernie Deitrick
external usenet poster
Posts: 5,441
Change event for data validation listbox
Steve,
Selecting a value from a Data Validation List should trigger the change
event - at least in Excel XP it does. Are you sure you have events enabled?
Often, if an error within an event will leave the application.enableevents
set to false. Try running this code:
Sub ResetEvents()
Application.EnableEvents = True
End Sub
HTH,
Bernie
MS Excel MVP
"Steve Parkinson" <Steve
wrote in
message ...
I'm trying to use the worksheet_change event to trigger some changes on a
worksheet. I have a cell with values restricted to a list, using the Data,
Validation menu. Picking a cell value from this listbox does not appear to
trigger a change event.
What can I do to get round this problem? I don't want to use a separate
listbox control since, in addition to trying to trigger code from the
listbox
value, it is also used in calculations using formulae in other cells.
Any help appreciated.
Steve
Reply With Quote
Bernie Deitrick
View Public Profile
Find all posts by Bernie Deitrick