Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
In Excel 2000, can I change the direction of the move selection a. | Excel Discussion (Misc queries) | |||
Drop Down Selection fires a module? | Excel Worksheet Functions |