VBA Get Message Alert when value in a range changes

[Mr Kaka]

Hi,
I am looking for a vba script that allows me to have an automatic alert whenever the value of a range change.

More specifically, on my case I have the range "Variation" (Range I3:M5) of Sheet_A which tracks the variation between "New Values" (Range C3:G5) and "Default Values" (Range O3:S5).
The range that i want to track is the "Variation" one, which is formula based only.
Please be aware that:

• the value of "Default Values" are static,
• the value of "New Values" are dynamic and are based on different parameters, among which also some reported on Sheet_A (Hyphotesis section). hence, for example, if i chage C11, "Variation" range does change

Mr_excel_task_assigned.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1			New Values						Variation						Default Values
2		Year	1	2	3	4	5		1	2	3	4	5		1	2	3	4	5
3		Revenues	1,890	1,105	106	134	177								1,890	1,105	106	134	177
4		Cost	572	328	22	26	32								572	328	22	26	32
5		Earnings	1,318	777	84	108	145								1,318	777	84	108	145
6
7
8
9
10		Hyphotesis
11		A	61%
12		B	30%
13		C	35%
14
Sheet_A

Cell Formulas
Range	Formula
C3:G4	C3	=Sheet_B!E10
C5:G5	C5	=C3-C4
I3:M5	I3	=C3-O3

 

[Micron]

You mean if a range value changes because a formula in the range calculated a new value, or if a user makes a change in a sheet? I suspect it is the former, in which case I don't know but would be happy to learn by following this thread. The other I have done.