Simple (?) Event Question

[JustinWWolcott]

I have a sheet with 14 columns of filtered data which generates a graph.

Is there any way to run a macro whenever one of these filters is changed (for example say I change class year from Junior to Senior, I want the macro to fire).

Thanks,
-JW

 

[Beate Schmitz]

Hello,

the filtering itself does not fire an event-macro. But if you e.g. use one formula like SUBTOTAL in my following example:

Excel Workbook
	A	B	C
1		13
2	Value1	Value2	Value3
3	43	23	63
4	43	97	28
5	45	39	95
6	34	5	98
7	66	3	77
8	28	79	89
9	82	38	36
10	3	16	19
11	6	23	22
12	85	39	45
13	69	74	49
14	72	59	32
15	46	19	42
Sheet

you can use a Worksheet_Calculate to start the code:

<div style="background-color:#FFFFFF; border-width:2px; border-style: groove; border-color:#ff9966; padding:4px;"><nobr><span style="font-family:Courier New,Arial; font-size:9pt ;" ><span style="color:#000080"; >Private</span> <span style="color:#000080"; >Sub</span> Worksheet_Calculate()
    MsgBox <span style="color:#800000"; >"Hello"</span>
<span style="color:#000080"; >End</span> <span style="color:#000080"; >Sub</span>
</span></nobr></div>

 

[JustinWWolcott]

works well, thank you