Popup Message When Criteria is Met on Multiple Worksheet

[vstr]

Hi,

I am new in this VBA coding, I hope some of you VBA experts can help me.

I have an excel workbook with 2 sheets ("Plan" and "Req")

I am trying to get a message box to pop up to notify me when I change each value on Plan Qty collumn (is higher than Req Qty).

In my spreadsheet, the Plan Qty is on "Plan Sheet" in column C and the Req Qty is on "Req Sheet" in collumn C.

Thanks in advance for any help

 

[hajiali]

Instead of Popup Message would you prefer a using the Waring Message on DV. Try this in your DV for you Plan Sheet

Mrexcel.xlsm
	A	B	C
2	No	Type	Plan Qty
3	1	LMXEC4
4	2	LMXEC6
5	3	LXEC20	13345
6	4	NXLMX12
Plan

Cells with Data Validation
Cell	Allow	Criteria
C3:C6	Custom	=INDEX(Req!$C$3:$C$6,MATCH(B3,Req!$B$3:$B$6,0))<>"-"

Mrexcel.xlsm
	A	B	C
2	No	Type	Plan Qty
3	1	LMXEC4	84000
4	2	LMXEC6	-
5	3	LXEC20	6876
6	4	NXLMX12	9868
Req

 

[vstr]

It's Worked. I almost gave up on this.

Never tried DV on Excel before, it can be my alternative.

Very thanks to you kind sir.

 

[hajiali]

Glad I could help.