Running code on a drop down selection change
I would like to know if it is possible to run a macro when a change in a data
validation drop down happens? I don't want it to run on other changes in the worksheet, only when a user makes a selection in a data validation drop down. Thanks, Steve |
You can use the worksheet_Change event to run the code, and check if a
cell with data validation was changed. There are notes on using this in different versions of Excel: http://www.contextures.com/xlDataVal08.html#Change And, there are sample workbooks he http://www.contextures.com/excelfiles.html For example, under Data Validation, look for 'Data Validation Combobox Named Lists' Steve Haack wrote: I would like to know if it is possible to run a macro when a change in a data validation drop down happens? I don't want it to run on other changes in the worksheet, only when a user makes a selection in a data validation drop down. Thanks, Steve -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 04:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com