| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
run macro automatically when cell content is changed?
I'm using advanced filter with several criteria to extract data to a new
destination. This works fine. I have a macro to run the filter. As of now I run the macro manually (i.e. by pressing a button) whenever I change the criteria. However, having the macro run automatically every time I change one of the criteria cells would be much better - and I'm sure it's possible - I just don't now how... Please help anyone.. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
run macro automatically when cell content is changed?
I managed to do this on my own :-) from a previous answer to a similar
question. "Kathrine" wrote: I'm using advanced filter with several criteria to extract data to a new destination. This works fine. I have a macro to run the filter. As of now I run the macro manually (i.e. by pressing a button) whenever I change the criteria. However, having the macro run automatically every time I change one of the criteria cells would be much better - and I'm sure it's possible - I just don't now how... Please help anyone.. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Comment in a cell be changed as the content in another cell ?? | Excel Discussion (Misc queries) | |||
| replace one tag in content of one cell and format not changed | Excel Discussion (Misc queries) | |||
| How can I automatically highlight a cell that has changed value | Excel Worksheet Functions | |||
| copying content of cell automatically to multiple cells | Excel Worksheet Functions | |||
| Macro on cell content | New Users to Excel | |||
Linear Mode
